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

[sirenetta1]

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!

 

[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]

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]

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]

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

 

[sirenetta1]

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.