Migrate data from one worksheet to another.

LUIS FREUND used Ask the Experts™
I wanted to migrate some data from one file to another one....

I have two excel files:  EE SAFE 1-12-18 and EE SAFE 1-18-18

On the EE SAFE 1-18-18 the orange column headers is what I want updated from another file EE SAFE 1-12-18 orange column headers it's data (columns O:V) on the MAIN_PN tab,
If there is a match.

I wanted to able to pick the previous file and update a current one with a button.  Please see attachments.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Administrator
You can use VLOOKUP function in columns O:V in the destination sheet.
Do you need an example?


Prefer not to use vlookup since the users will more likely mess that up....
Roy CoxGroup Finance Manager

How do you want to update the data? If you want to compare each PO in each book then that could be a slow process.

VLOOKUP would be automatic and the formulas can be protected using WorkSheet protection

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today