RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 150
- Office Version
- 2016
- Platform
- Windows
Good Morning.
I have a simple copy paste code from workbook to another but my question is, how do I get it to find a specific sheet based on value in C1 and paste there?
I want it to copy the Truck Schedule Builder worksheet and paste it into the truckschedulesduelsides workbook but find the specific sheet that has the same name as the value in C1 on original copy sheet (truck schedule builder)
Any help would be much appreciated.
Thanks,
I have a simple copy paste code from workbook to another but my question is, how do I get it to find a specific sheet based on value in C1 and paste there?
VBA Code:
Workbooks("Truck Schedule Builder.xlsm").Worksheets("SUN").Range("A2:D9").Copy _
Workbooks("Truckschedulesduelsides.xlsm").Worksheets("Sun 4-3").Range("A2")
I want it to copy the Truck Schedule Builder worksheet and paste it into the truckschedulesduelsides workbook but find the specific sheet that has the same name as the value in C1 on original copy sheet (truck schedule builder)
Any help would be much appreciated.
Thanks,