Post a sample of your actual sheet names please.

I am confused. Your first post said they were "organization #1 etc."

Where will you be entering the first formula to fill down?

Which sheet and what cell?


Gord


On Sun, 13 Jan 2008 16:51:11 -0800, Jenn wrote:

lets see if I put this in correct


=INDIRECT("'1" & (ROW(31) & '"!C31")

Organization # is Sheet 1
the Row Number in Sheet 1 is 31
and the Cell # is C31

"Gord Dibben" wrote:

Jenn

For the first question try EditReplace

What: '5!'

With: '6'!

Replace all.

For second question, use the INDIRECT function to fill down or across

=INDIRECT("'organization #" & (ROW()) & '"!B12")

entered in A1 and copied down.

To copy across, change ROW() to COLUMN()


Gord Dibben MS Excel MVP

On Sun, 13 Jan 2008 13:59:00 -0800, Jenn wrote:

I need to select multipe cells and change just the reference page for the
selected cells, not the other reference information in the cell. Find and
Replace does not work. Example, this are four cell, I want to just change the
5 (which is the refence page).

='5'!C36, ='5'!C377, ='5'!C38, ='5'!C39

Or, I am trying to create a spreadsheet for example January's information
will have 10 rows that reference 10 different organization that are
referenced from Sheets 1 through 10 (sheet 1 is organization #1, etc...) When
I try to use the autofill function, instead of changing the the reference
page number it will increase the cell number (autofill down) or autofill to
the right will increase the column name but not change the page or cell
number. What I really need to be able to do is autofill down keeping the
same column and cell but increasing the page reference.

Any help would be appreciated. Thanks in advance.