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....