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.
Last seen: 2 months 2 weeks ago
Joined: 07/02/2016 - 06:26