LUIS FREUND
asked on
Migrate data from one worksheet to another.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
VLOOKUP would be automatic and the formulas can be protected using WorkSheet protection
ASKER