Copying selected worksheets (value and formatting only) VBA

[Benjeejump]

Hi,

I have virtually no VBA knowledge, and am looking to copy the same selected sheets every week, and paste their values and formatting only into a new workbook. I think this can be done with a VBA macro?

 

[Benjeejump]

Hi Kenny,

Any chance you know of something that can be added to this to remove blank rows from the bottom of all sheets? These would previously had formula running in them, but when data is moved across they are just blank. I know the process manually is to ctrl end, and then delete the remaining blank rows underneath and save. Doing the same for each sheet. But not sure if there is something that will do this in an automated way. I was hoping kutools delete blank rows would do it, but actually it leaves the blanks at the bottom.