troubleshooting Question

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

Avatar of James Kyritsis
James Kyritsis asked on
Microsoft ExcelVBAMicrosoft Office
10 Comments2 Solutions97 ViewsLast Modified:
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
Mike in IT
IT System Administrator
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros