I have a 1*125 cell named "C". inside C I have 125 tables (456*12 tables). I want to fill every blank cell in 1 to 4 columns of these tables using the value written in the cells in the same column. please look at this example to explain what I want:
column 1 column2
blank blank
24 red
24 red
blank blank
24 red
24 red
24 red
so I want to change the above table to this:
column 1 column2
24 red
24 red
24 red
24 red
24 red
24 red
24 red
I want to apply this for every 125 tables in the C (column 1 to 4) I don't want to change the rest of the columns.
I was attached to C for you.
if any other question you have I would answer so quick.
thank you all.
Best Answer