Excel Macro: Organize Two Sheets
Budget: $10 – $30 USD
I work with two separate raw Excel worksheets every cycle and need a repeatable way to pull only the fields I care about, place them side-by-side, and have the results presented clearly in a single summary sheet. What I’m after is a VBA macro (or Power Query script if you prefer) that automates the whole flow:
• I’ll paste or import the two raw tabs into the workbook.
• Running the macro should extract the columns I specify, align matching items, and group everything “by categories” (the chosen structure for this project).
• The output must has summary tab and as selected catagory tabs as needed must start with bold headers and use subtle alternating row colours so it’s effortless to scan. Beyond that, keep the overall layout tidy and easy to read—no clutter, consistent column widths and cell formats.
Feel free to code in native VBA or leverage Excel 365 features such as dynamic arrays; whichever method you choose, it should run with a single button click and require no additional add-ins. I’ll provide two sample files so you can test. Hand over a macro-enabled workbook (.xlsm) with well-commented code and a short note explaining where to adjust source column names or ranges. Once I can drop in fresh data, press the button and get the formatted summary instantly, we’re done.
• I’ll paste or import the two raw tabs into the workbook.
• Running the macro should extract the columns I specify, align matching items, and group everything “by categories” (the chosen structure for this project).
• The output must has summary tab and as selected catagory tabs as needed must start with bold headers and use subtle alternating row colours so it’s effortless to scan. Beyond that, keep the overall layout tidy and easy to read—no clutter, consistent column widths and cell formats.
Feel free to code in native VBA or leverage Excel 365 features such as dynamic arrays; whichever method you choose, it should run with a single button click and require no additional add-ins. I’ll provide two sample files so you can test. Hand over a macro-enabled workbook (.xlsm) with well-commented code and a short note explaining where to adjust source column names or ranges. Once I can drop in fresh data, press the button and get the formatted summary instantly, we’re done.