Linking workbooks

[Ed Lovell]

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 into the master form. It is
simple enough to set up a formula to allow this but the
formula won't let me copy and paste the formula to fill
in the entire spreadsheet. I would have to manually enter
the formula in each cell, 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!

 

[Anon]

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 into the master form. It is
simple enough to set up a formula to allow this but the
formula won't let me copy and paste the formula to fill
in the entire spreadsheet. I would have to manually enter
the formula in each cell, 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!

What do you mean when you say: "the formula won't let me copy and paste the
formula"? What happens when you try to copy and paste it? What is the
formula?