Create automatic index

[Mearsy]

Hi Guys
Not sure if this is in the correct area or even if this can be accomplished.
I have a master spreadsheet which contains buttons that when used inserts another sheet behind the master. I want to know if, when a new sheet is inserted by using the buttons it will automatically list the new sheet on the master spreadsheet, thereby creating an index of sheets.

[DannyJ]

Where do you want the indexed sheets to be written? Cell wise of course.

Danny

[DannyJ]

Hi Mearsy,

Personally, the way I would do this is to set the code below up as a module and then tell it to call the module from your subs so that on a click of either of the buttons. Once the sheet has been created, it will be listed.

Please Login or Register  to view this content.

Once that is set up as a module. Write in the existing codes.

Please Login or Register  to view this content.

Regards

Danny

[Mearsy]

Hi Danny
Thanks that's great it works, but if I wanted it in row 20?
Many thanks

[DannyJ]

You mean row 20 and continue down from there?

[DannyJ]

Try

Please Login or Register  to view this content.

This will put it in H20 down. Change the 8 if you want to change the column and if you want it to START at a different row then change where it says i = 20.

Regards

Danny

[Mearsy]

Hi Danny

This works but it puts the index in the sheet I'm inputting, I want the index on the Master Sheet. The original code worked but I just wanted to move it down the sheet, i.e. row 20.
Many thanks for your help.