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

sirenetta1

Board Regular
Joined
Feb 11, 2004
Messages
169
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. :biggrin: 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! :pray: 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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,886
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Feb 11, 2004
Messages
169
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
Joined
Feb 11, 2004
Messages
169
Can the link sort automatically?

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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,886
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

sirenetta1

Board Regular
Joined
Feb 11, 2004
Messages
169
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? :eek: THANKS!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,886
Office Version
  1. 365
Platform
  1. Windows
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.
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
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
Top