Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easier way to copy formula that are linked?
I've been troubled with copying a formula and need to know if there is an
easier way to do it: I have two Excel spreadsheets "a" contains the majority of the information while I need "b" is a tracking sheet based on some of the cells in "a". I link cells in "b" to "a" with no problems and when I update "a" the "b" cells update accordingly. On the "b" spreadsheet 10-12 cells (in columns) are linked to the "a" spreadsheet - The Problem: when I copy lines in "b" (because I run out of them) I have to change each column cell to reflect the correct "a" link. Please help - if that's possible! -- Michelle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
copy formula every x rows | Excel Worksheet Functions | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions |