MS Excel - Macros for consolidating values from multiple sheets into a single sheet
- by SpikETidE
Hi everyone...
Consider i have 4 workbooks with the following structure...
1. Main.xlsx
Name Jan Feb Mar
A
B
C
2. Jan.xlsx
Name Jan
A 3.3
B 6.4
C 5.3
3. Feb.xlsx
Name Feb
A 1.3
B 3.4
C 5.5
4. Mar.xlsx
…