Macro to Copy and paste filtered data to new workbook

Hi All

I am having a small issue and I'm looking for a bit of help. Please see Code below.

It runs correctly but there are a few changes I think that bring up errors when opening that export file, see attached image. The file needs to be pasted in the new file as pasted Special "Values" and needs to be saved as an XLS.

The second thing I need to copy is a hidden worksheet from the same file to the new XLS file,

I would appreciate any help. If I'm not explaining myself clearly please ask.

Thanks in advance

Adam

Please Login or Register  to view this content.

I will pay 20$ for a solution