----- Original Message ----- From: "Pete Holsberg" <[EMAIL PROTECTED]>
Subject: [users] Calc Question
I have a bunch of spreadsheets that I wish to combine. They are income and
expenses for a non-profit organization. A new sheet is issued each month
and it shows income and expense for that month and for YTD.
I would like to extract the figures in the "monthly" column and build a
spreadsheet that shows the numbers for each month.
Is there an easy way to do this?
Thanks.
--
Pete Holsberg
Columbus, NJ
If I understand your question correctly, you can create one new worksheet
with columns for January, February, March... etc. , and a "Year-to-date"
column across columns A to whatever... Then use formulas down each column
that link to the separate worksheets (that are created each month) for that
month. A linking formula looks something like ='file path and file
name'#sheetname.cell reference; but the easiest way to create the formula is
to have both worksheets open. Edit the cell you want the new formula to
appear (start by entering the = equal sign), then click on the source
worksheet, navigate to the correct cell, and hit enter. The linking formula
has now been entered in your destination cell.
Does this help?
-- John V
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
