An easy one I know but it's driving me nuts ! Please help me.
Posted by Marko on March 05, 2001 11:08 PM
I've read all the thread and can't find how to do this.
Column A1 to A1000 has a series of numbers (formatted as text)
Column A row 1 Column B row 1
Notice that cell A1 has the same string as cell B3
I want to create a macro that searches for unique strings in column a that aren't alreadt in column B anywhere. Then I want those unique numbers added to the first available blank cell in column B
I know this will be some simple lookup function or code but I've been trying all day and can't work this out.
Thanks in advance. Can you please email me at firstname.lastname@example.org in case I can't get back on here for a while.