Excel VB Script to Enter Data based on whether a Cell is empty or not

Hello everyone...

I have to insert data into Column C of a spreadsheet based on whether Column A or B are empty or not.

Attached excel file "test1.xls" shows the output format as well as what i have so far in terms of macro and here is the code which I have so far..

Please Login or Register  to view this content.

basically, as you would notice that the first 2 entries in Column C match the desired output because the number of entries in Column B is only one. The moment there are more entries than one in Column B, I am unable to skip the rows eg. skipping rows from C6 to C10 in this case.

Any help in this regard is greatly appreciated...

Thanks all in advance :-)

Since what you want to do can be done with a simple formula, in C2, then copied down:

=IF($A2<>"", $A2&".pdf", "")


...then you can do that in a macro too with no looping:

Please Login or Register  to view this content.