Hi,
I've got the following codes which filter for the "adj" in the "total" page and copy the results to the "sum" page. It then goes back to the "main" page where the instructions sit.
However, the "adj" field is not there all the time.
Would you know how can I get the macro to do the "copy and paste" if the "adj" field is there but when "adj" is unavailable; directs it back to the "main" page?
Thanks.
Sheets("total").Select
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=19, Criteria1:="=ADJ"
Range("W1").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Sheets("sum").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("main").Select
Range("A1").Select
Bookmarks