Post the code, and tell us where it's failing.

Regards,
Fred.

"Mustang" wrote in message
...
Hi,

I have recorded a macro that uses the advanced filter to give me all work
that was carried out between two dates.

This data is copied to a new sheet.

There is a third sheet which contains a pivot table to analyse this data.

This was working perfectly when I had test data in, now that we are
inputting real data with different dates to my test it is failing.

I am running the macro from a button.

If I go through the exact steps of the macro it works, so I re-record it
and
it fails to work.

Any ideas why?

Thanks