Linking Specific Sheets(tabs) to One Master Workbook

R

rts1

New Member
Joined
Aug 12, 2011
Messages
6
Hello,

I have several Cost Report Excels, each with about 10 different sheets. I want to take the Budget Analysis Sheet from each one and link it only to one Master Budget Analysis Excel where they may all be quickly reviewed. Is there a way to do this so it it keeps updating along with the original? It will let me link the entire Exel, but not specific sheets inside an excel. Thanks!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

G
  • Question Question
Using a set date to prevent access to Excell tabs and macros
Replies
1
Views
231
Micron
M
H
  • Question Question
Avoiding INDIRECT when referencing and comparing ranges in different workbooks
Replies
1
Views
836
RoryA
RoryA
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
614
Amo840812
A
R
  • Locked
  • Question Question
Linking independent and dependent drop down costs to master budgets
Replies
1
Views
349
Fluff
Fluff
R
  • Question Question
Linking independent and dependent drop down costs to master budgets
Replies
0
Views
278
RookieBookie
R

Forum statistics

Threads
1,224,586
Messages
6,179,730
Members
452,939
Latest member
WCrawford

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