Oh that makes sense now. I am using the consolidatedsheetsfromworkbooks and I am getting a debug error on
fName = Dir(fPath & "*.xlsx") 'start looping through files one at a time
My master workbook is called "Master". and i have three tabs that are labeled the same as the ones in the workbooks I am wanting to merge. Any suggestions?
Oh that makes sense now. I am using the consolidatedsheetsfromworkbooks and I am getting a debug error on
fName = Dir(fPath & "*.xlsx") 'start looping through files one at a time
My master workbook is called "Master". and i have three tabs that are labeled the same as the ones in the workbooks I am wanting to merge. Any suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks