Autofill Worksheet Names

  • Thread starter Thread starter Panda
  • Start date Start date
P

Panda

Good Afternoon,

I know that when autofilling a formula, the cell
references will automatically increment one column letter
or row number (dependant on autofilling horizontally or
vertically).

My question is...

In a 3-dimensional formulae is there a way of
automatically incrementing worksheet names instead of cell
references?

For example - the formulae ='Sheet 1'!$B$7 should change
to ='Sheet 2'!$B$7, ='Sheet 3'!$B$7, ='Sheet 4'!$B$7, etc.

Unfortunately, I can't find anything in the knowldege-base
that comes close to an answer.

Please Help!!!

Panda.
 
Back
Top