merge data from to sheets using common data in column A

[inukman]

I have 2 worksheets. One contains user info and the other contains asset info. Both sheets use an employee id in column a. Is there a function to merge the data into one sheet using the employee id column?

Thanks

 

[GTO]

Presuming you are wanting a third sheet combining the two, or moving records to the appropriate id row, a fairly simple bit of code should work.

Just to rule out - the employee IDs are listed only once on ea sheet, correct?

Mark

 

[inukman]

I got it. I used access to merge the sheets into one datebase and export to excel.

 

[GTO]

Very cool! I would not have thought of that.