how to type in 1 workbook & automatically insert in another book?

I

IM

If I am trying to create account balances and I have two different
worksheets. How do I type information in one worksheet and automatically have
that information inserted into the other work sheet with the same values
without copying and pasting a link?
 
T

tim m

It probably depends on how many cells you need duplicated and whether you
have a standard set up or whether it will change often but if you go onto the
2nd sheet and insert the address of the cells from sheet 1 in sheet 2 you
will get the results automatically in sheet 2.

For example if you want to enter data in A1 of sheet 1 and have it show up
in A1 of sheet 2 you would double click on A1 of sheet 2 and enter =Sheet1!A1
(Or you can double click the cell enter = and then click on the cell in
sheet 1 and hit enter, that will stick the address in for you.
 
Top