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
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