I have 30 Plus tabs in my work book. I am trying to auto fill Tab Names to make it easy. Auto fill to me is to drag a cell and have the formating change for the next cell.
To make it easier i have named my cells 1 - 32 I though this would make it easier for auto fill
I am trying to drag this down a column
='1'!A$1:J$1
A1:J1 is a merged cell so there will just be a transfer of the students name on the top of the page.
'1' is the tab name, but when i drag the cell down the column I would like the next cell to say
='2'!A$1:J$1
='3'!A$1:J$1
='4'!A$1:J$1
And so on.
I will need to use this auto fill in other cells also.
Right now it is not auto filling the tab name. i can get it to auto fill and change the A1:J1 if I take off the $ sign. When I take off the $ it will still not work on the Tab name.
Any Help would be great.
thanks
To make it easier i have named my cells 1 - 32 I though this would make it easier for auto fill
I am trying to drag this down a column
='1'!A$1:J$1
A1:J1 is a merged cell so there will just be a transfer of the students name on the top of the page.
'1' is the tab name, but when i drag the cell down the column I would like the next cell to say
='2'!A$1:J$1
='3'!A$1:J$1
='4'!A$1:J$1
And so on.
I will need to use this auto fill in other cells also.
Right now it is not auto filling the tab name. i can get it to auto fill and change the A1:J1 if I take off the $ sign. When I take off the $ it will still not work on the Tab name.
Any Help would be great.
thanks