How to make two new tabs pull data from each other

L

Leighg1809

New Member
Joined
Jan 26, 2022
Messages
2
Office Version
  1. 365
Platform
  1. 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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
438
ChrisMac1
ChrisMac1
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
524
Akuini
Akuini
N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
149
NKUNZI
N
B
  • Question Question
VBA to Insert Column, Lookup to another workbook, return results.
Replies
1
Views
201
dermie_72
D
E
  • Solved
Copy a certain set of data from one sheet to another depending on the date typed in
2
Replies
10
Views
562
myall_blues
myall_blues

Forum statistics

Threads
1,224,813
Messages
6,181,117
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top