We help IT Professionals succeed at work.
Get Started

How do i import and manipulate data from one excel worksheet to another?

Last Modified: 2017-11-15
Hi Everyone,

I hope you can help me.

I have a example worksheet containing the following data:

2017 Barcode      2018 Barcode      Publisher Name                   Carton Qty      Weight      
9781782085225      9781782087168      AVONSIDE                           50                    330

I need to import and manipulate the data into the following format in another worksheet:

CAL Code        Barcode              Publisher Code    Weight   Carton Qty      Pallet Qty      
CAL12345      9781782087168      ASIDE                     .330        50                     2,500

In order to do this:
- I have a table containing 2017 Barcodes and their corresponding CAL Codes,
- I have a table containg Publisher Name and their corresponding Publisher Codes,
- Carton Qty is simply a trainght copy,
- Pallet Qty is equal to Carton Qty multiplied by 50, and
- Weight is equal to Weight devided by 1000
Watch Question
IT System Administrator
Distinguished Expert 2017
This problem has been solved!
Unlock 2 Answers and 10 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE