linking worksheets and copying formulas in cells

[Ed]

I am developing a budget calendarization for the non
profit organization that I work for. We are funded by
different funders and I have created a workbook for each
funder and linked the various spreadsheets in the
individual sheets to give me a funders total spreadsheet.

Now I want to create a master calendarization form that
will allow me to pull all of the monthly totals for the
various ledger accounts from each of the funders totals
spreadsheets into the master form. It is
simple enough to set up a formula to link the cells on
the individual workbooks to the master workbook using the
formula (= and then clicking on the appropriate cells in
the different workbooks). However once I do this and then
try to copy the formula across the different months it
only copies the references to the original cells that
were entered. When I do the same acion on different
spreadsheets in the same workbook the cell references
change so that all of the proper cells are added. The
same does not happen when I try to link different
workbooks. I seem to have to manually enter
the formula in each cell which will be too tedious and
potentially
error prone.

Does any one have any ideas on how to simplify this task
so that I can create a copy & paste formula that will
link the appropriate monthly cell?

I'd appreciate any ideas out there!

 

[KevinF]

You may have already reviewed this but; within the
formula you created, does it have the "$" before the
column reference and the row reference? If so, you must
remove these, so that when you copy the formula, the cell
reference will change accordingly.
Kevin

 

[miranda]

I am having a similar problem. I am trying to create a loan portfoli
where one sheet in the workbook has all the information about differen
loans and other sheets are linked to the main data sheet to creat
charts and display the information differently, etc. When I try t
move data around in the main data sheet (i.e. cut and paste the dat
from one row of cells to another), the links change and i get the #REF
value. For example, when I want to move data from C6 to C30, I cu
from C6 and paste to C30, but all the cells in other worksheets tha
previously linked to C30 show error messages. How can I keep the link
from changing? How can I keep these other cells linked to C30 in th
data sheet regardless of what is moved into the cell? Help

 

[alcorjr]

You should use copy-paste and then clear up the original position
instead of cut
Hope it helps!;

 

[miranda]

Thanks, I had tried that actually, but since the portfolio I am making
isn't really for me to work with once it's finished, I'm concerned
about convenience, and I dont want to have to explain this to everyone
who works on it. If there is a way to keep the links from changing
after cutting and pasting I would like to know.

 

[Dale Hymel]

Select the cell /cells ,then doubling clicking on one of the borders, drag
to new location.