Macro to create worksheet, change it's position, and paste date into it.

[dcgrove]

Hi, I need a macro that will create a new blank worksheet, move it to the last spot and paste the entire contents of the sheet named "master" into the newly created sheet.
I have tried to do this with the recorder but have been unable to get it to work.

Thanks!
Clayton

[Leith Ross]

Hello Clayton,

Here is the code...

Please Login or Register  to view this content.

[JBeaucaire]

Any particular name for this worksheet? Or method of creating a name?

[dcgrove]

The new sheet will not be named anything in particular.

Leith, I will give you code a try when I get home in a little while.

Thanks!
Clayton

[dcgrove]

Leith, the code you provided makes an exact copy of the "Master" sheet, but all I need copied is the stuff on it. Using your code, I came up with the macro below. It creates a new sheet at the end, so all I need it to do now is copy the entire master sheet to the new sheet. I hope that makes sense. It is 1AM here.

Please Login or Register  to view this content.

[Leith Ross]

Hello Clayton,

This macro will copy the "Master" sheets values only to the newly created sheet. No formatting is copied over, just the cell values.

Please Login or Register  to view this content.

[dcgrove]

Thanks leith! If I wanted to paste the formatting as well, what would I need to change? I ask because I have another application for this macro the calls for the data and the formatting to be pasted.

Thanks again!
Clayton

[JBeaucaire]

You're straying from the simple answer...Leith already showed you how to make an exact copy of a sheet. Just add one more line to remove all the formulas on that copy:

Please Login or Register  to view this content.

[BBXguy]

Ok, this works awesome with a button. How can I make it so that when they click that button, it names that new worksheet with today's date?

Thanks!

[Leith Ross]

Hello BBXguy,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.