Hi All,
I have been researching online and found a piece of VBA code which I have edited to match my needs (working). The code is setup to look at a folder location and merge all excel .xlsx files into a master sheet. However, I am having difficulty amending the code to only read and copy a specific sheet from the source files. I only need to copy one specific sheet ("Sheet2") from each file :-). Appreciate the help:
ThanksPlease Login or Register to view this content.
Bookmarks