How to make a backup sheet of original data?

[storefoto]

How do I make a copy of a worksheet in excel as a backup in the same workbook before making modifications?

Please help.

I need the excel to do this automatically in the beginning so that when user starts modifications the original sheet is backup automatically.

Thanks

 

[Trebor76]

Hi storefoto,

Welcome to MrExcel!!

Run this while on the tab in question:

ActiveSheet.Copy After:=Worksheets(Worksheets.Count)

HTH

Robert

 

[storefoto]

Thank you very much for the reply!
How to run this code? Where to run? Sorry I am very new to excel.

 

[Trebor76]

The macro simply copies the active (i.e. the one you're on) to the end of the workbook. It's exactly the same as:

1. Right clicking on the active tab
2. Clicking on Move or Copy... from the shortcut menu
3. Clicking on (move to end), selecting Create a copy and then clicking OK.

When you said "automatically in the beginning" I thought you already had some code which mine would just form a part of.