Excelexcel86
Board Regular
- Joined
- Feb 28, 2023
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi guys I have roughly 50 sheets in one workbook now each sheet has vba code where when I click the button on that sheet it opens up my csv data . The problem I have is each sheet has the same code apart from where to get the file from as they are all in different folders so is there a macro I can run on a master sheet that opens all 50 sheets for me into one master sheet . Any help much appreciated