Macro for Copy current worksheet and paste it to a new worksheet

[green4000]

Hi Excel gruss,

I'm looking to copy a range of cells in an open worksheet as a value while maintaining the formatting and paste it to a new worksheet by opening/creating one (so cant' be name specific because the new workbook might named "Book1" or Book7" ect. depends on how many I have opened).

I'm working with multiple sets of data being pulled by vloop up from other worksheets within the file. I'm using drop-down list to flip through the data and make the data populated using formula.
The goal is that I want to repeat this process as often as possible by clicking a button. so that I can print them out individually in a separate workbook.

Thanks in advance for your help!

[Greg M]

Hi there,

See if the following code does what you need - it copies the details of the selected property to a new workbook named as the selected property name:

Please Login or Register  to view this content.

The highlighted value may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M