How to add continous task sheets to a workbook using buttons

[Jayzon]

Hi
I am going to try my luck here again as this forum has been very helpful before.

I am trying to create a task managing workbook that with a button on the "Frontpage" will create a task sheet like "Task page 1" with the progress and priority info added on this page by the push of a button. At the same time clearing this sheet readying it for a new task that should be named "Task page 2" and so on continuously.

I am not sure if this is possible, but it sure sounds like a vba / macro kinda thing to me. I am totally blank in this area, other than making very basic buttons to navigate in workbooks.

Thank you very much in advance for any help / push in the right direction.

Cross posted at: https://www.mrexcel.com/board/thread...ttons.1164828/

[BadlySpelledBuoy]

Slightly different approach in the attached. If you want a blank task sheet to work from then rather than copying an existing one and clearing it I've created a blank "template" version of it and hidden it away.

The below code attached to a button will unhide the template, copy it, rename the new copy then hide the template away again.

Note I added a new button to the front page as the button you had there kept throwing up an error message when I tried to use that.

Please Login or Register  to view this content.

Is this anywhere near what you were trying to do?

BSB

[Jayzon]

Thanks for the effort BBS.

And its one step closer, i would really like the data / info entered in the "Frontpage" to be transferred into the "new" copy of the page.

I am thinking that to get around the cleaning of the frontpage i could go for a "Clear sheet" button to prepare for a new entry / copy.

When or if done i would like only the Frontpage and the Stats page to be unhidden.

Thank you very much again for you effort.

[BadlySpelledBuoy]

Maybe this then?

Please Login or Register  to view this content.

BSB

[BadlySpelledBuoy]

Or this if you want to hide all the sheets other than Frontpage and Stats afterward.

Please Login or Register  to view this content.

BSB

[Jayzon]

Or this if you want to hide all the sheets other than Frontpage and Stats afterward.

Please Login or Register  to view this content.

BSB

This is great i can work with that.

Thank you very much BSB

[BadlySpelledBuoy]

No problem at all. Happy I could help

BSB