update data between sheets

[smurphree]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Have multiple sheets in one workbook. When I change info on one, would like other sheets to be updated to show new info.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Have multiple sheets in one workbook. When I change info on one, would like
other sheets to be updated to show new info.

What does it mean when you say "would like other sheets to be updated"?

If you want a cell in Sheet2 to display the value in the changed Sheet1
cell B2, then in that Sheet2 cell, use

=Sheet1!B2


Similarly, if you want the value in cell J10 of Sheet2 to be twice the
value of Sheet1, cell B2, then

=Sheet1!B2 * 2

If you want something else, it would be helpful to be more specific.

 

[Phillip Jones, C.E.T.]

Depends upon what you need.

recent I've had to create a multi sheet workbook for some bills of my
mothers I am keeping up.

I was helped with it. to transfer the sum total of that sheet to another

the formula went something like this:

first determine the row and column coordinates of the information you
want to transfer to another sheet say for example Grand total of entire
sheet one is locate Column D and row 10 making the item D10.

formula *=Sheet!D10* this would be placed say on sheet two in cell Al

then if you have additional bills for next month add this to the total
of the month for sheet2 by simply summing A1 with the rest of the
totals. now say your totals for sheet to (not counting A1 is in H11
then on sheet three you use *=Sheet2!H11* and you have that in A1 on
sheet three and in A2 you'd put *=Sheet1!D10*

Then you have grand total for sheet 1 an2 on sheet three then you add
other numbers and so on.

NOTE: on Macintosh you must use Exclamation point at the sheet and
number. Because colons on Mac in some case are used for system purposes.

 

[Phillip Jones, C.E.T.]

Pleas ignore the *'s I was try to bold face some of my text obviously it
didn't work for some reason.

 

[Phillip Jones, C.E.T.]

Okay I am posting HTML so that I can emphasize correctly.

See if the shows up better.

Phillip Jones, C.E.T. wrote: Depends upon what you need.

recent I've had to create a multi sheet workbook  for some bills of my mothers I am keeping up.

I was helped with it. to transfer the sum total of that sheet to another

the formula went something like this:

first determine the row and column coordinates of the information you want to transfer to another sheet say for example Grand total of entire sheet one is locate Column D and row 10 making the item D10.

formula =Sheet!D10 this would be placed say on sheet two in cell Al

then if you have additional bills for next month add this to the total of the month for Sheet2 by simply summing A1 with the rest of the totals, would be grand total of both pages. now say your totals for sheet to  (not counting A1 is in H11 then on sheet three you use =Sheet2!H11 and you have that in A1 on Sheet3 and in A2 on Sheet 3 you'd put =Sheet1!D10

Then you have grand total for Sheet1 and 2 on sheet three then you add other numbers and so on.

NOTE: On Macintosh you must use Exclamation point at the sheet and number. Because  colons on Mac in some case are used for system purposes.

[email protected] wrote:
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Have multiple sheets in one workbook. When I change info on one, would like other sheets to be updated to show new info.




-- Phillip M. Jones, C.E.T. "If it Ain't Broke, Don't Fix it" http://www.phillipmjones.net http://www.vpea.org mailto[email protected]

 

[smurphree]

Example: Sheet 1 in workbook is the master working sheet for an organization, containing all data--member names, addresses, committees, and member committee preferences. Other sheets contain the same info but represent individual committees. If data is changed or updated( address, phone number, committee preference, etc.) on the master data sheet, will those changes automatically convey to the item-specific sheets?

 

[CyberTaz]

Bottom line: If the same data has been actually typed on the separate sheets
or has been copied & simply pasted to other sheets changing the content on
any one sheet *will not* change/update the content on the others.

In order for that to happen the content on the other sheet/sheets must be
*linked* to the content on the "master" sheet by way of a formula link or
Lookup & Reference function.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Phillip Jones, C.E.T.]

The formula I showed does reflect changes from one sheet to the other.
In facts some of you on this forum suggested several different ways to
make this happen. and each total does up date on each page as something
is entered on a given sheet.

However; the op, now that he has explained would seem to be in need of a
Relational Database where one sheet is interrelated to another. I am not
aware that Excel has that capability. If it does not, then his best bet
is to use FileMaker Pro (version 10 now).