Find matching cell in other sheet and copy cell from different column
Sorry I'm relatively new to this. I can write basic code but this is beoynd me. I think it might need a vlookup function but I'm not sure. I tried searching the forum but couldn't find anything close enough that I could modify. Maybe I'm not searching the right keywords?
I have two sheets (OLD and NEW) from a database of items we buy from our suppliers.
After a recent software update the Stage Numbers (used to break up a job budget) got a bit muddled. The reason I can't do a straight copy and paste of the column is that there are new items inserted all through the sheet.
A unique id for each item is in column B ("Item Number"), the Stage Numbers are in column AN.
I need to be able to do the following:-
For every row
- find the corresponding item number in the OLD sheet.
- copy the Stage Number from column AN to column AN in the NEW sheet.
I have uploaded a very short version of the file. The actual list is over 50,000 items. In the file I have uploaded all the Stage Numbers happen to be 3.5 in OLD and 3.3 in NEW, but stored as text. Not sure if this is relevant.
Thanks in advance.
Re: Find matching cell in other sheet and copy cell from different column
Try, in cell AN2 in the NEW sheet:
and drag down.
Trevor Shuttleworth - Excel Aid
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1