Data Comparison

Hello Everyone:

I have a situation that I need help with....
Please refer to the attachment for my example

Here's the scenario:
Basically, the data sheet will always be a constant. On the sort sheet, I need to add a column after "A", and in that column I need to refer to the data sheet in each field of that balnk column and pull the employee number and place it beside each corresponding employee name all the way down to the last employee then I need to delete the empoyee name column from the sort sheet. the number of rows on the sort sheet will not always be the same as sometimes empoyees do not work.

Anything you can do to help would be greatly appreciated.!!!

Thanks
Ru-DoGG

Try this...

Add a column between A & B
In A2 type =VLOOKUP('Sheet1 Sort'!A2,'Sheet2 Data'!A:B,2,0)
Copy this down to the rest of column B
Copy column B
While column B is still selected, edit-paste special - values
Delete column A

Or as a macro you could do..

Please Login or Register  to view this content.

Worked Flawlessly!!! Thanks a billion!!!!!