button to copy a sheet to a new sheet

[broke]

Hi, I have a sheet where I can import a csv file. then i do calculations, this is on a monthly basis.
Now I want to have a button that will copy the whole sheet (just the values in this sheet) to a new sheet for storing purpose.
So that my original sheet wont get changed and is ready for the next month. by importing the next csv file all values from before get changed.

[millz]

Try this code? Run it on the sheet that you want to be copied.

Please Login or Register  to view this content.

[broke]

Thank You, so far so good. would be nice if the copied sheet would keep the format of the original (color, font, column size, etc).
Also if it could get copied to the end, so that it is the last sheet in the workbook. I guess I made the task more special than it is by saying just the values. Basicly it should be a 1:1 copy of the original file, except that the original file has a link to data and the copy has the values..

[millz]

Then maybe:

Please Login or Register  to view this content.