We help IT Professionals succeed at work.

Hoist the colors! We’ve added location flags to usernames sitewide, so it's easier to connect with the global community on EE. View My Profile

x

Migrate data from one worksheet to another.

71 Views
Last Modified: 2019-08-21
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

IT Administrator
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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

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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.