please help me to get the data in one excel with naming conversion of the excel.
As I am 72 excel reports in one folder with different names and I need all the data in one excel sheet with the name versions.
example:
1. sheet with the name for "ABC corp.xls"
2. sheet with the name for "DEF corp.xls"
3. sheet with the name for "GHI corp.xls"
all in one excel with the name conversion for excel ABC cop.10 rows after that DEF cop.15 rows then GHI cop. 20 rows like wise.
Thanks in advance.
Bookmarks