How to create new sheet with exactly the same data on it!!!

Hi guys,

I have a workbook with about 10 sheet of data that i using to other sheets for my formulas. My workbook is about recipes costing and every time i use the same sheet, i put my data and then i copy it at the end of my sheets. I am trying to create a button that when i click on it to create a new sheet with exactly the same formulas and data. I try to create button but unfortunately the formulas and the data were not correct.
Is it possible to create a button to make my worksheet easier?
Thank you!!!

Hi there,
when You mentioned that You are working with a lot of sheets... How should "the button know" which worksheet has to be duplicated?
I prefere a shortcut key to call a simple macro from active sheet = sheet You want to copy:

Please Login or Register  to view this content.

Hope it helps

Regards

M

Hi aachillis,

Creating a button involves a macro.

You can avoid that by creating a copy of the sheet VERY easily.

Just hold down the Ctrl key, click on the sheet tab you want to duplicate, and drag to the right. You will see a small black triangle appear above the tab markers - you can drag and drop wherever you like.

All your formulas will be preserved, and you will have a replica of the original sheet. YOu can then rename it, and use it as you wish.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

When you reply please make it clear WHO you are responding to by mentioning their name.

Originally Posted by David A Coop

Hi aachillis,

Creating a button involves a macro.

You can avoid that by creating a copy of the sheet VERY easily.

Just hold down the Ctrl key, click on the sheet tab you want to duplicate, and drag to the right. You will see a small black triangle appear above the tab markers - you can drag and drop wherever you like.

All your formulas will be preserved, and you will have a replica of the original sheet. YOu can then rename it, and use it as you wish.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

When you reply please make it clear WHO you are responding to by mentioning their name.

Thank you for your help but i have the same problem again. I am using dynamic drop lists with formulas that is the reason i have this problem.
Thank you again!!!

Originally Posted by Miroslav R.

Hi there,
when You mentioned that You are working with a lot of sheets... How should "the button know" which worksheet has to be duplicated?
I prefere a shortcut key to call a simple macro from active sheet = sheet You want to copy:

Please Login or Register  to view this content.

Hope it helps

Regards

M

Thank you for your help. Can you explain little bit more. Sorry but i am a newbie

Hi there,

see attachement.

The shortcut key for duplicating is CTRL+d.
Does not matter if Your dropdown source is located on sheet You are going to duplicate, or it is a named range.

To view the code with comments, press ALT+F11 to step in to VBA.

Regards

M

CopySheet.xlsm

Originally Posted by Miroslav R.

Hi there,

see attachement.

The shortcut key for duplicating is CTRL+d.
Does not matter if Your dropdown source is located on sheet You are going to duplicate, or it is a named range.

To view the code with comments, press ALT+F11 to step in to VBA.

Regards

M

Attachment 318690

Thank you Miroslav !!!