Have worksheet names displayed in table

  • Thread starter Thread starter Excel Thomas
  • Start date Start date
E

Excel Thomas

Hi all,

I have two questions.

1st: How can I make a printout of all the worksheet names I have in m
file? Or can I make a table which shows these names in a ro
Alphabetically?

I have made a file which contains 250 worksheets, ahem :-)

2nd question:
All worksheets except the first, have the same layout.

In the first sheet (no1), I want to make a table of which cell a
contains the value of cell a1 of the worksheet no 2.

Cell a2 must contain the value of cell a2 from worksheet no2.

In row b of this table, the same values A1, A2 etc. must appear o
worksheet nr 3 and so on.

I add and remove worksheets all the time, so I lose track in the tabl
of which worksheets I have added already and which ones I forgot.

So a macro which does this automatically would be nice, but I have n
clue how to..

Many thanks
 
Hi Excel Thomas!

See:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Once you have built your table of contents you should be able to sort
it alphabetically.

On referring to cells in other worksheets just type = and then
navigate to the cell and press Enter.

On addition the formula will re-adjust the address. Not sure that you
want this. For a macro that refers to same cell in preceding or
following sheet I suggest that you post to programming. I can
certainly see quite a few problems that are best handled by
programming people.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top