| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
First, you need to understand that Excel can't "dump" information from one sheet to another. However, it *can* read information from one location in another. Therefore, if, for example, on your Fiscal Qtr sheet you have information in cell C12 that you want to see in cell D20 of your Qtr 1 sheet, you would put this formula in cell D20 of Qtr 1: ='Fiscal Qtr'!C12 Follow this format for the remaining cells on your various sheets. Then, as you enter or edit data on the master, the corresponding cells on the designated sheet will automatically update. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=345944 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for an easy way to replace letters with acutes | Excel Worksheet Functions | |||
| is there an easy way to move parts of cells around | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| Easy way to sum multiple worksheets | Excel Worksheet Functions | |||
| Is there an easy way to do this? | Excel Worksheet Functions | |||
Threaded Mode
