Hi Brian,
I have 50 excel files with 7 sheets in each file and i would like to consolidate the same into one file with 7 sheets. The file name consists of the name of the organisation. In order to differentiate the contents i would like to append the file name in each sheet that is imported so that when i consolidate i get the organisation name in the table.
Can you help me out with this please.
Regards
Padma T
padmathiagarajan
Offline
Last seen: 3 years 4 months ago
Joined: 07/02/2016 - 06:26
Hi Padma, I have a script that does that: http://ideascripting.com/ideascript/add-filename
Is this what you are looking for or are you looking for something else.
Brian
Hi Brian,
This is good but it works when the database is open in IDEA. So when i have many files, i need to do it one by one.
I have to consolidate 50 excel files with 7 sheets in each file. So i would like to have file name in each of the sheets imported. Some of the files would have blank data also. Can you help me with a script to handle mutiple files and sheets.
I am enclosing a sample for your reference.
Hi Padma,
Can you confirm my understanding. You would like a script that does the following:
Is that right? Thanks for the example files.
Brian
Yes Brian. Your undestsanding is right.