MS Excel - Copying columns from multiple worksheets into a single worksheet based on some condition
- 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... Can someone enlighten me about the possible options that i have to do this...?
Thanks for your time....