Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfering data from one sheet to another
I am trying to create a master sheet that I can edit and the changes will
automatically reflect in the dependent sheets... I am have been using formulas like this "='Main Sheet'!A7" However if I insert a blank row so I can add new data on the "Main Sheet" then excel automatically changes my formula in the dependent cell so that it stays "locked" to the original data from A7 what I want is for cells in the dependent sheets to ALWAYS reflect what is on the main sheet so that WHATEVER I change on the main sheet will reflect in the others ie: I do not want excel to "adjust" my cell refereces but to always show exactly what is in the correspoding cells on the master sheet Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfering data from worksheet to another | Excel Discussion (Misc queries) | |||
Transfering data across worksheets | Excel Discussion (Misc queries) | |||
Transfering Data from Several Sheets to another | Excel Worksheet Functions | |||
Transfering data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Transfering and totalling corresponding data to other worksheets | Excel Discussion (Misc queries) |