Leighg1809
New Member
- Joined
- Jan 26, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a document that I’ve made with two tabs
“shift report” and “machine data” which both pull various formulas and data from each other
Is there a way I can create a button / macro that would copy both tabs but the formulas for the new ones would correspond with each other
Eventually you’d have
Shift report week 1 & machine data week 1
Shift report week 2 & machine data week 2
Shift report week 3 & machine data week 3
“shift report” and “machine data” which both pull various formulas and data from each other
Is there a way I can create a button / macro that would copy both tabs but the formulas for the new ones would correspond with each other
Eventually you’d have
Shift report week 1 & machine data week 1
Shift report week 2 & machine data week 2
Shift report week 3 & machine data week 3
