update multiple sheets from one central sheet in the same workbook

MBenedikt

New Member
Joined
Feb 4, 2025
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi,

I'm trying to create a workbook where we would update each sheet, and that should automatically update the central sheet.
If it's easier, then we could insert the data into the central spreadsheet, and it should automatically update the other sheets, according to the sheet name in a table on the central sheet.

We have expenses and income for each unit on separate tabs, I want to combine these into one.
This is a unit tab:
1738671896006.png


and this is what I want the central tab to look like:
1738671919911.png


thank you very much, I hope this is clear.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Welcome to the Board!

Take a look at using the new FILTER function. This allows you to have your own "central" sheet of data, and related subsets of data that are linked to the central data and update automatically/dynamically.

See: FILTER function - Microsoft Support
 
Upvote 0
Thank you very much.
I will check it and see if I can manage.
I am not so familiar with excel, do you know of any explanation of the filter function 'for dummies'?
 
Upvote 0
Thank you very much.
I will check it and see if I can manage.
I am not so familiar with excel, do you know of any explanation of the filter function 'for dummies'?
Check out that article - it explains it in detail.
There are lots of other articles or tutorials you can find out there on it if you go a Google search (or YouTube search, if you prefer vidoes).
So depending on your preferred method of learning, you should be able to find something that suits you best.
 
Upvote 0
Thanks

Perhaps this is above my paygrade!
I'm finding it hard to understand how the filter function should combine the sheets.
Was my question clear enough?
 
Upvote 0
It doesn't combine the sheets.
It is going the other way, as you said presented this option:
If it's easier, then we could insert the data into the central spreadsheet, and it should automatically update the other sheets, according to the sheet name in a table on the central sheet.

So, we start with the complete set of data on your first sheet, and then the Filter works to dynamically take subsets of your main data (first filter for "Income", second for "expenses").
 
Upvote 0
Whichever way you decide to go (enter all data on the main sheet, and use FILTER to filter the Income and Expense records on the other sheets; or whether to enter the individual information on the Income and Expense sheets, and combine them all on the main sheet), if you need help doing it, if you could post some actual example records that we can copy/paste, we can help you do this.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
 
Upvote 0

Forum statistics

Threads
1,226,264
Messages
6,189,928
Members
453,582
Latest member
Browny2821

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