E
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!
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!