Migrate data from one worksheet to another.

LUIS FREUND
LUIS FREUND used Ask the Experts™
on
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.
C--Users-lfreund-Desktop-EE-SAFE-1-.xlsm
C--Users-lfreund-Desktop-EE-SAFE-1-.xlsm
Comment
Watch Question

Do more with

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

Author

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

Commented:
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