Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to type in 1 workbook & automatically insert in another book?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to type in 1 workbook & automatically insert in another book?
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. "IM" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a macro automatically on workbook open | Excel Worksheet Functions | |||
Blank workbook opens when try to open any existing book | Excel Discussion (Misc queries) | |||
how do you have rows automatically insert in excel? | Excel Worksheet Functions | |||
MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET. | Excel Worksheet Functions | |||
Index/Match to look up a value in one workbook and insert it into. | Excel Discussion (Misc queries) |