Skip to main content

I have an excel file

and I want to add a list of vars by the column (not by row, so i will run on the cell A1 and then A2 and then A3 ...)

and I want that each time that I will write to the excel it will check where is the first column that free

for example:

it will check if column C is free

if - write to the cell C1 and the next var will go into C2 ETC...

else - go check column D

 

and next run will check what letter is open...

to do that I can create a list of all the letters and run on a loop

but the Q is - is there a better way?

Be the first to reply!

Reply