Hi ,
I have a requirement where I need to copy data from multiple excels present in one directory
Requirement are
1)Pick data from Second Worksheet of each Workbook
2)From the Worksheet pick only two fields , say Column B and C
3)From the two fields, fetch data from 5th row onwards till last data record
4)Paste this data from all workbooks into a single output excel.
Appreciate help on this.
Bookmarks