John Viestenz wrote:
----- Original Message ----- From: "Pete Holsberg" <[EMAIL PROTECTED]>
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?
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?
Yes, thanks! Is there a way to do this column-by-column?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
