Amarnath.chegu
New member
- Joined
- May 29, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
HI, can you please help me in fetching sheet names of another excel into current excel? For example, one file sample1.xls with 3 sheet names "a","b","c". i wanto get those 3 names into sample2.xls
I need this entire process to be automated. i .e whenever file sample1.xls arrives into the folder,sample2.xls should fetch the sheet names of the
sample1.xls
FYI, I am able to fetch the sheetnames of current excel file by creating the formula =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1))," ") and with the help of index(sheetlist,row())
Please help me ASAP.
I need this entire process to be automated. i .e whenever file sample1.xls arrives into the folder,sample2.xls should fetch the sheet names of the
sample1.xls
FYI, I am able to fetch the sheetnames of current excel file by creating the formula =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1))," ") and with the help of index(sheetlist,row())
Please help me ASAP.