Macro to copy data from one format to another into a different

Silence

New Member
Joined
Jul 20, 2009
Messages
8
Hello all,

So here's the situation: I download an Excel file (File A) and this file has data on products based on different regions. The regions are fixed columns and the products are always in the same order. For example, product A, product B, product C - all appear in the same order. This is relevant because if the download is done for data over the past 3 months, then the data is displayed 9 times - Product A on one line, Product B on second line, Product C on third line - That's data for the first month. For the second month, Product A on the fourth line, Product B on the 5th line, and Product C on the 6th line. Get the drift? Each product is sold in different regions, such as Quebec, Total Ontario, and Midwest. What I do is for each column (or region), I calculate the average for each product. For example, Product A in Qubec (colum D) will have a calculated value in cell D5, product B in D6, and product C in D7. For Total Ontario (column E), product A in E5, product B in E6, and product C in E7.

My goal: I have another file (File B) that gets populated and there are different tabs based on regions. There is a sheet for Quebec, a sheet for Total Ontario, and a sheet for Midwest. Each of these sheets has Product A, Product B, and Product C. I require the data from D5 from File A to be transferred into file B into cell H7 ALWAYS; data from D6 into cell H10 ALWAYS etc. The on the next tab, Total Ontario, I require data from file A in cell E5 to be transferred into file B - tab Total Ontario - cell D8 ALWAYS...etc.

If someone can assist me in creating this macro, i will really appreciate it! If you require further clarification, kindly ask me here or email me at sharjeelarif@gmail.com.

Thank you,
Sharjeel
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top