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
Name Mar
A 1.3
B 3.4
C 5.5
I need to combine them like
1. Main.xlsx
Name Jan Feb Mar
A 3.3 1.3 1.3
B 6.4 3.4 3.4
C 5.3 5.5 5.5
And i need to automate the process...
And i guess i can do this with macros...? Can anyone suggest some way with which i can proceed with the macro?
Thanks for your time....