Autofilter Criteria Equals #N/A Sometimes

[timbo1957]

Hi,

I have a macro which runs through a set of 4 worksheets which are identical in format. To finish off the task I need to Autofilter Row 1 with the criteria

Please Login or Register  to view this content.

Then copy the contents of A2:C2 to the end of the data in A2 to A2 on a Sheet Called Not On Cons Rep.

Could someone supply me some code that will do this for four sheets and get around the problem of what to do if there are no values that match Criteria1 i.e. of there are no #N/A's then move on to the next sheet?

I have attached an example with the final result on the Not On Cons Sheet.

Many Thanks

[jaslake]

Hi timbo1957

There is no code in your upload. Do you have current AutoFilter code? If so, what does it look like look like? What's this code look like?

I have a macro which runs through a set of 4 worksheets which are identical in format