VBAnewbie82
New Member
- Joined
- Nov 13, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I have two large workbooks that I need to combine as one. First report is the budget for specific year (workbook BUDGET with one sheet “Sheet1”) and second is estimate for same year (workbook ESTIMATE with one sheet “Sheet1”). Layout of these are identical as follows, only the numbers or the money in budget columns change:
Row1 = cost center numbers for each column
Row2 = cost center names
Row3 = header “Budget” for budget or estimate or header “Results” for current results
Row 4 to x = actual budgets and results in currency
Example for workbook “BUDGET” Sheet1 could look like this:
5555; 5555; 6666; 6666; 7777; 7777;
MAN; MAN; ICT; ICT; HRM; HRM;
Budget; Result; Budget; Result; Budget; Result;
900; 600; 700; 200; 500; 400;
Example for workbook “ESTIMATE” Sheet1 could look like this:
5555; 5555; 6666; 6666; 7777; 7777;
MAN; MAN; ICT; ICT; HRM; HRM;
Budget; Result; Budget; Result; Budget; Result;
1200; 600; 400; 200; 800; 400;
Example for what I am trying to achieve should look like this:
5555; 5555; 5555, 6666, 6666; 6666; 7777, 7777; 7777;
MAN; MAN; MAN; ICT; ICT; ICT; HRM; HRM; HRM;
Budget; Estimate; Result; Budget; Estimate; Result; Budget; Estimate; Result;
900; 1200; 600; 700; 400; 200; 500; 800; 400;
Macro could make this for a new workbook or use ESTIMATE workbook as the one where it is bringing columns from BUDGET. There are around 90 different cost centers = aroung 180 columns in each workbook and around 600 rows in both of them.
Row1 = cost center numbers for each column
Row2 = cost center names
Row3 = header “Budget” for budget or estimate or header “Results” for current results
Row 4 to x = actual budgets and results in currency
Example for workbook “BUDGET” Sheet1 could look like this:
5555; 5555; 6666; 6666; 7777; 7777;
MAN; MAN; ICT; ICT; HRM; HRM;
Budget; Result; Budget; Result; Budget; Result;
900; 600; 700; 200; 500; 400;
Example for workbook “ESTIMATE” Sheet1 could look like this:
5555; 5555; 6666; 6666; 7777; 7777;
MAN; MAN; ICT; ICT; HRM; HRM;
Budget; Result; Budget; Result; Budget; Result;
1200; 600; 400; 200; 800; 400;
Example for what I am trying to achieve should look like this:
5555; 5555; 5555, 6666, 6666; 6666; 7777, 7777; 7777;
MAN; MAN; MAN; ICT; ICT; ICT; HRM; HRM; HRM;
Budget; Estimate; Result; Budget; Estimate; Result; Budget; Estimate; Result;
900; 1200; 600; 700; 400; 200; 500; 800; 400;
Macro could make this for a new workbook or use ESTIMATE workbook as the one where it is bringing columns from BUDGET. There are around 90 different cost centers = aroung 180 columns in each workbook and around 600 rows in both of them.