G Guest Sep 18, 2007 #1 I have a project in Excel that has about 300 tabs. Is there a way that I can get a list of the tabs only?
I have a project in Excel that has about 300 tabs. Is there a way that I can get a list of the tabs only?
P Peo Sjoblom Sep 18, 2007 #2 If you right click the on the arrows to the left of the tabs you will get a list If you need a list in your cells you need to run a macro http://www.mvps.org/dmcritchie/excel/buildtoc.htm there is a UDF that will list all sheets on that page -- Regards, Peo Sjoblom "DocumentControlPrincess"
If you right click the on the arrows to the left of the tabs you will get a list If you need a list in your cells you need to run a macro http://www.mvps.org/dmcritchie/excel/buildtoc.htm there is a UDF that will list all sheets on that page -- Regards, Peo Sjoblom "DocumentControlPrincess"
G Guest Sep 18, 2007 #3 Cool thanks! -- ~Christina Peo Sjoblom said: If you right click the on the arrows to the left of the tabs you will get a list If you need a list in your cells you need to run a macro http://www.mvps.org/dmcritchie/excel/buildtoc.htm there is a UDF that will list all sheets on that page -- Regards, Peo Sjoblom "DocumentControlPrincess" Click to expand...
Cool thanks! -- ~Christina Peo Sjoblom said: If you right click the on the arrows to the left of the tabs you will get a list If you need a list in your cells you need to run a macro http://www.mvps.org/dmcritchie/excel/buildtoc.htm there is a UDF that will list all sheets on that page -- Regards, Peo Sjoblom "DocumentControlPrincess" Click to expand...
