Create duplicate woksheets that auto update from main workbook

C

Chuck Norris

New Member
Joined
Jul 24, 2014
Messages
4
Excuse the title...

I have a 10 tab workbook. Each tab contains a schedule of parts for a different job (same client). Is it possible to easily create an auto updating copy of individual tabs linked directly to the original workbook. So that changes made to the original are automatically made to the copy?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
607
Amo840812
A
F
  • Question Question
Filtering/Copying a table via VBA.
Replies
2
Views
407
frobeniusabnorm
F
K
  • Solved
Code to search job id from multiple sources and update main spreadsheet.
2
Replies
10
Views
654
mumps
mumps
C
  • Question Question
Updating both sheets in two workbooks from either sheet source
Replies
6
Views
230
chazrab
C
M
  • Question Question
Formulas Not Updating Automatically in Investing Spreadsheet
Replies
3
Views
718
mflatt23
M

Forum statistics

Threads
1,224,352
Messages
6,178,066
Members
452,822
Latest member
MtC

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