Creating a Excel Spreadsheet

[jrrscientist]

Hi Everyone,

I need help in creating a spreadsheet and hopefully someone can help me.

The spreadsheet will have a main worksheet that will have like a profile information. It will also have a button than when clicked it will create a new worksheet with the label on the bottom with the current date. The new worksheet will copy a form page.

I am able to do this manually just wanted to see if I can automate this actions.

Thank you for your help.

 

[alansidman]

Where is the form page located? ie. Sheet Name. What is the range of the form page? ie. Range could be something like this: A1:F12, but tell us what your range is.

This can all be done with some VBA, but we need some additional details to make it work in your situation.

 

[jrrscientist]

Where is the form page located? ie. Sheet Name. What is the range of the form page? ie. Range could be something like this: A1:F12, but tell us what your range is.

This can all be done with some VBA, but we need some additional details to make it work in your situation.

Yes, that range would work fine.
thank you