LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Sheet Referencing - autofilling sheet names

Is there a way to easily reference sheet names.

Here is my problem:

i have several sheets named 01,02,03,04... and so on,
I have a summary sheet that i would like to reference all the individual
sheets.
I start at the top and refernce sheet 01, then i would like to drag down so
that the next row is referencing sheet 02 and so on. This does not happen
when i drag the cell down.

Is there any way to achieve this. I tried typing out the cell names in
another column and referencing that cell inside the ' ', but that didn't seem
to work.

Thanks,

Pat
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilling Sheet Name in Formula Julie Excel Discussion (Misc queries) 5 March 21st 09 10:24 PM
formula referencing a column - autofilling in a row ??? Arcadiaz04 Excel Discussion (Misc queries) 2 March 14th 07 08:08 PM
Referencing Sheet Names Stuart Grant New Users to Excel 1 October 4th 05 03:43 PM
copy formula referencing sheet name to another sheet Tat Excel Worksheet Functions 1 June 26th 05 03:00 AM
referencing a sheet named in a cell then using data from that sheet gbeard Excel Worksheet Functions 4 April 15th 05 08:42 AM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"