Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link all dependent cells to a "new" independent cell??
I am working with two sheets in excel 2007. One with assumtions (sheet 1)
and this is linked to an other (sheet 2) which uses alot of formulas linked to the data in sheet 1. Anyway. I want to create a third sheet which shall be a copy of sheet 2, except that it shall be using other data than what sheet 2 do. Is it a way to get excel to adjust all cells in sheet 3 to pick data from another cell in sheet one?? There is a lot of formulas to change so it is not possible to change every cell in sheet 3 by hand. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link all dependent cells to a "new" independent cell??
If you want all instances of, say Sheet1!A2 to Sheet1!A3, use find..
find/Replace Sheet1!A2 with Sheet1!A3. If you want all your formulas to find the cell just below, then just make a copy then just copy all your cells down a row and delete Row 1. so, basically, it depends on what you mean by reference a different cell... "Anders_Royal_Institute_of_Technology" wrote: I am working with two sheets in excel 2007. One with assumtions (sheet 1) and this is linked to an other (sheet 2) which uses alot of formulas linked to the data in sheet 1. Anyway. I want to create a third sheet which shall be a copy of sheet 2, except that it shall be using other data than what sheet 2 do. Is it a way to get excel to adjust all cells in sheet 3 to pick data from another cell in sheet one?? There is a lot of formulas to change so it is not possible to change every cell in sheet 3 by hand. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I "paste link", and "transpose" at the same time? | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Need to link excel "cell" to a pre saved PDF file?? How do I do th | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |