ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

Utilities for an excel book

(1/4) > >>

Contro:
I have an excel book with many sheets.
I would like to list, in the more easy way, the sheets to a txt file or similar

How can I do this ?

Best Regards
 :-*

katykaty:
ASAP Utilities has a function to create an index sheet with named links to each worksheet. You could easily take that list, select and copy all, and paste as values.

http://www.asap-utilities.com/

Contro:
ASAP Utilities has a function to create an index sheet with named links to each worksheet. You could easily take that list, select and copy all, and paste as values.

http://www.asap-utilities.com/
-katykaty (March 03, 2014, 02:45 PM)
--- End quote ---

Really ?
Running to try
 :-*

Contro:
simply wonderful

 :-*

TaoPhoenix:
ASAP Utilities has a function to create an index sheet with named links to each worksheet. You could easily take that list, select and copy all, and paste as values.

http://www.asap-utilities.com/
-katykaty (March 03, 2014, 02:45 PM)
--- End quote ---

Heh yep! But I don't have Excel here at home so I didn't jump in, but I recall using it at work to do a few other things!

Navigation

[0] Message Index

[#] Next page

Go to full version