Have data circulating between sheets

[Guest]

H
I must get a way to have text and data automatically copied in the same excel document but from one sheet to another, so that a general table can subdivide in several particular ones. How can I do it?

 

[Gord Dibben]

You can link cell data on one sheet to a cell on another sheet.

In Sheet2 in a cell type an equal sign(=) then without hitting <ENTER> switch
to Sheet1 and select a cell, say A1.

Hit <ENTER> and the formula on Sheet2 will be =Sheet1!A1

When you alter the data in Sheet1!A1, it will also change in Sheet2.

Gord Dibben XL2002

 

[Mark Adams]

Use a cell reference to the sheet where the main data is entered.

ie if data in cell A1 on sheet1 needs to goto sheet2 in cell b4 then enter

=sheet1!a1

in sheet2 at cell b4.

This will enter 0 if nothing is in sheet1!a1.

Either disable "display zeros", or change refernce to:

=if(sheet1!a1<>"",sheet1!a1,"").

Obviously, in either case, the name "sheet1" etc can be replaced by whatever
you have called each sheet.

Mark

Hi
I must get a way to have text and data automatically copied in the same

excel document but from one sheet to another, so that a general table can
subdivide in several particular ones. How can I do it?