# How do I update multiple sheets with one click in Excel?

#### sirenetta1

##### Board Regular
This is my first time posting to the board. I'm not sure the best way to answer my question, so I thought I'd ask some professionals. At work, I have three sheets in a workbook to enter in financial information. All of these sheets have the same column headings, though some sheets have extra column headings. They each have different styles (one looks more professional than the other)

It takes a lot of time each day to go through each sheet and add the same information. I'd like to simplify this somehow, but I'm not sure how to do it. I'm an average Excel user, and I have not attempted to program with Excel, though I could learn how to do that, if I knew what I could do to solve my problem.

So my question is: How can you transfer information in Excel to multiple sheets with one click? Is Excel the best program for this? I also have Access here, but I have not used it.

Any advice is appreciated! ray: Thanks!

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Joe4

If all these sheets contain the same information, can use direct links, i.e. Sheet 2 cell A1, enter formula = Sheet1!A1, etc.

Or, you can use formulas like VLOOKUP to look-up values from other sheets (see VLOOKUP function in Excel help)

#### sirenetta1

##### Board Regular
Thanks for your advice!! Would it be possible for when I'm linking, that it could sort in ABC order? So that if I have a list of names, when I enter it in on sheet one, it will appear on sheet 2 and 3 in ABC order?

Thanks!!

#### sirenetta1

##### Board Regular

Thanks for your advice!! Would it be possible for when I'm linking, that it could sort in ABC order? So that if I have a list of names, when I enter it in on sheet one, it will appear on sheet 2 and 3 in ABC order?

Thanks!!

#### Joe4

If you sort it on sheet 1, it should filter to the other two sheets as well.

#### sirenetta1

##### Board Regular
So there isn't a formula that can do that without sorting everything on sheet 1?

Okay, so what if on sheet 1, two of my columns were DATE and NAME. On sheet 2, I need the columns to be sorted by DATE. On sheet 3, I need the columns to be sorted by NAME.

How would I do that without having to do it manually? THANKS!

#### Joe4

If you want the different sheets to have different sorting options, but want updates on sheet 1 to filter to all three pages, I think this would involve some VBA code.

Actually, looking at your project, this appears to be something that would be better handled in Access. Create your table that holds all your data (you can also create a nice looking user form too, to update the data). Then you can create numerous forms/reports from this table (or a query based on the table) that would give you your different views/sorts. Then changes to your table/user form would update the information in all places.

Replies
4
Views
67
Replies
5
Views
335
Replies
3
Views
69
Replies
3
Views
92
Replies
1
Views
93

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,100
Messages
5,768,095
Members
425,452
Latest member
htay44

### 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.

### Which adblocker are you using?

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

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