HI all,
I have around 495 excel data sheets, each having 3 columns and 101 rows. The first column values are same for all the sheets. The Title for column No 2 and 3 are same however their values are different. Now I wish to append column no 2 and 3 from all these excel sheets into one master sheet. Can somebody please help me in doing this.