auto updating a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to update info in a worksheet and i simply don't know how. okay say for instance i have a grocery list that displays the product,price,how many and the total.......and then i have another worksheet that has the same info and if i made changes to the second worksheet it automatically changes the numbers on the first worksheet. i hope i explained it right if anyone can help me please explain in the simpliest form. thank


Erika
 
Erika

Use "links" from one sheet to the other.

Basics.....in a cell on sheet1 type an = sign but don't hit ENTER.

Click on tab of sheet2 and select a cell then hit ENTER key.

Sheet1 cell will contain a formula =sheet2!cellref

When cell in sheet2 is changed, the cell in sheet1 will return that value.

See also Copy>Paste Special>Paste Link.

Gord Dibben Excel MVP
 
Do you want the information on the 2nd sheet to change? If no, look in upper
border of the Excel window and see if [grouped] is shown... if so, right click
on one of the worksheet tabs and select ungroup

If this does not answer your ? Please repost and explain a little better as to
what you are trying to do and what is actually happening


: i am trying to update info in a worksheet and i simply don't know how. okay
say for instance i have a grocery list that displays the product,price,how many
and the total.......and then i have another worksheet that has the same info and
if i made changes to the second worksheet it automatically changes the numbers
on the first worksheet. i hope i explained it right if anyone can help me please
explain in the simpliest form. thanks
:
:
:
: Erika
 
Back
Top