software

Please share whether it is possible to somehow imbed sheet names contained in
a cell to allow for relative referencing in a formula...so autofill can be
used to fill in sheets....

I have a spreadsheet which contains a column with account numbers:

ACCT #
1 =SUMIF(SheetReference1,Cell,SheetReference1)
2 =SUMIF(SheetReference2,Cell,SheetReference2)
3 =SUMIF(SheetReference3,Cell,SheetReference3)
4 =SUMIF(SheetReference4,Cell,SheetReference4)
These Account numbers are also the name of sheets.
I need to use the SUMIF function to extract information from each sheet.
However, when I copy paste the formula down I have to manually go into each
cell and change the sheet reference. This can be quite annoying because the
SUMIF function contains the sheet reference twice. If I could imbed the
Account Number as a sheet reference I could save myself a lot of typing....

Does anyone have any suggestions or workarounds?

--
Ted----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Hi!

What are the sheet names? Do they have a sequential pattern like the default
sheet names: Sheet1, Sheet2, Sheet3 etc.?

Biff

quot;Tedquot; gt; wrote in message
...
gt; Please share whether it is possible to somehow imbed sheet names contained
gt; in
gt; a cell to allow for relative referencing in a formula...so autofill can be
gt; used to fill in sheets....
gt;
gt;
gt;
gt;
gt; I have a spreadsheet which contains a column with account numbers:
gt;
gt; ACCT #
gt; 1 =SUMIF(SheetReference1,Cell,SheetReference1)
gt; 2 =SUMIF(SheetReference2,Cell,SheetReference2)
gt; 3 =SUMIF(SheetReference3,Cell,SheetReference3)
gt; 4 =SUMIF(SheetReference4,Cell,SheetReference4)
gt;
gt;
gt;
gt; These Account numbers are also the name of sheets.
gt; I need to use the SUMIF function to extract information from each sheet.
gt; However, when I copy paste the formula down I have to manually go into
gt; each
gt; cell and change the sheet reference. This can be quite annoying because
gt; the
gt; SUMIF function contains the sheet reference twice. If I could imbed the
gt; Account Number as a sheet reference I could save myself a lot of
gt; typing....
gt;
gt; Does anyone have any suggestions or workarounds?
gt;
gt; --
gt; Ted
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions