TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
I have the following
In Reports.xlsm (which is where this code lives) I'd like to have a cell (A1 on a sheet named "Control") where the user types the sheet name we want to copy from in New Data - so say they type July then instead of looking in Sheet "Export 2", my macro would look in July.
Many thanks.
I have the following
VBA Code:
Dim wsCopy As Worksheet
Dim wsDest As Worksheet
Set wsCopy = Workbooks("New Data.xlsx").Worksheets("Export 2")
Set wsDest = Workbooks("Reports.xlsm").Worksheets("All Data")
In Reports.xlsm (which is where this code lives) I'd like to have a cell (A1 on a sheet named "Control") where the user types the sheet name we want to copy from in New Data - so say they type July then instead of looking in Sheet "Export 2", my macro would look in July.
Many thanks.