Table of Products

Try this modified macro. I deleted the "Product" title as I wanted all the links to start at the same row leaving row 1 empty for you to add tiltes manually if you want.
I supposed your sheet were name A-1, A-2, B-1, B-2, B-3, C-1, etc. As I am using the first letter of the sheet name to locate the link in the proper column, you must have them named properly.

Please Login or Register  to view this content.

Thanks for you help! I'll give it shot!

Your code works pretty well to seperate the pages by their first letter. However I may have made my initial example a bit to simplistic. I guess a more accurate representation of what I would like to achieve is this:
The worksheets are labelled like: LWP-1, LWP-2...LAP-1, LAP-2.., LHP-1, LHP-2, and some random names.
And then the table to like:
LAP LHP LWP MISC
LAP-1 LHP-1 LWP-1 Random1
LAP-2 LHP-2 LWP-2 Random2

I'm not sure if the best way to go about it is to sort by second letter, but then some of the Randoms may get put into the other three columns. Or maybe to search for "LAP", "LHP", "LWP" and sort that way.

Thanks again for all your help.

Are these the only 4 columns you'll ever need?
And the sheets will always be named "LAP", "LHP", "LWP"?
Any other named sheets would be put in the fourth column, right?

Maybe not ever but for the very long immediate future.
Ya just the 3 names and then everything else goes in the Miscellaneous column.

Thanks!

I almost solved the problem...the script below categorizes the LAP, LHP, LWPs into their proper columns. The only problem I have now is that I can't figure out how to put everything else into a miscellaneous column. Probably not the prettiest code...or most logical but it works haha.

Please Login or Register  to view this content.

Here is a way to do it.

Please Login or Register  to view this content.

Ah that works perfectly! Thanks p24leclerc!