Hello Everyone!
I have to copy data from 10+ workbooks and paste it into a master workbook. I need to first of all create the layout like this for the master workbook
Then, all the workbooks are located in a folder on my desktop: D:\Desktop\Macros 2\psi flash file
All the workbooks contain a sheet named 'model koro', I have to open each workbook, go to sheet 'model koro’, filter the column B to "Curr. Flash" and go to column F to filter it to "Sell Out (Market)" & "Sell Out (disty)" & "Channel Inv (excl.disty)" & "Channel Inv (inc.disty)" and then select columns range B to BO (hide the columns anything ealier than 202004) starting from row 11 to row ‘x'(the last row can vary in each workbook), ctrl+v (copy), and paste the data range into master worksheet. In the master worksheet, I paste the data in Columns A to AA and continue pasting/appending the data as I copy data from more workbooks. Eventually, the master workbook has the data in columns A to AA from every workbook in one sheet.
The columns range remains constant in all the sheets (model koro ) of every workbook. Each workbook contains multiple sheets, but I am only interested in sheet ‘model koro’
I have to repeat the same steps for 10-30 workbooks and continue pasting/appending the data into master sheet. So, I was wondering if someone could please help me to create a VBA code for this? I'm really new to VBA and would really appreciate your help!
Please let me know if you require any clarification.
Many thanks! =)
I have to copy data from 10+ workbooks and paste it into a master workbook. I need to first of all create the layout like this for the master workbook
| Version | Code | Key Figure | 202004 | 202005 | 202006 | 202007 | 202008 | 202009 | 202010 | 202011 | 202012 | 202101 | 202102 | 202103 | 202104 | 202105 | 202106 | 202107 | 202108 | 202109 | 202110 | 202111 | 202112 | 202201 | 202202 | 202203 |
Then, all the workbooks are located in a folder on my desktop: D:\Desktop\Macros 2\psi flash file
All the workbooks contain a sheet named 'model koro', I have to open each workbook, go to sheet 'model koro’, filter the column B to "Curr. Flash" and go to column F to filter it to "Sell Out (Market)" & "Sell Out (disty)" & "Channel Inv (excl.disty)" & "Channel Inv (inc.disty)" and then select columns range B to BO (hide the columns anything ealier than 202004) starting from row 11 to row ‘x'(the last row can vary in each workbook), ctrl+v (copy), and paste the data range into master worksheet. In the master worksheet, I paste the data in Columns A to AA and continue pasting/appending the data as I copy data from more workbooks. Eventually, the master workbook has the data in columns A to AA from every workbook in one sheet.
The columns range remains constant in all the sheets (model koro ) of every workbook. Each workbook contains multiple sheets, but I am only interested in sheet ‘model koro’
I have to repeat the same steps for 10-30 workbooks and continue pasting/appending the data into master sheet. So, I was wondering if someone could please help me to create a VBA code for this? I'm really new to VBA and would really appreciate your help!
Please let me know if you require any clarification.
Many thanks! =)
