stenlake1
06-20-2007, 06:11 AM
Hi,
Sorry my mind has gone completely blank... I have this:
<Attached spreadsheet> (have added red what i want the code to do)
Basically, if there is a number in Column "C", I want the code to insert a number (starting at 1) in Column "B". Then goto the next cell, if there is a value there, put a "2" in the next one, until there is no value in column C. I would much appreciate peoples help as my brain has died :)
Thanks
Sorry my mind has gone completely blank... I have this:
<Attached spreadsheet> (have added red what i want the code to do)
Basically, if there is a number in Column "C", I want the code to insert a number (starting at 1) in Column "B". Then goto the next cell, if there is a value there, put a "2" in the next one, until there is no value in column C. I would much appreciate peoples help as my brain has died :)
Thanks