To get rid of the auto filter just use this amended code:
Sub Macro2()
Sheets("Store1").Select
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=13, Criteria1:="=Completed", Operator:=xlOr, _
Criteria2:="=Fabricating"
Range("C3:C10000").Select
Selection.Copy
Sheets("Summary").Select
Range("B5").Select
ActiveSheet.Paste
Selection.SpecialCells(xlCellTypeBlanks).Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
Sheets("Store1").Select
Cells.Select
Selection.AutoFilter
Range("A2").Select
Sheets("Summary").Select
End Sub
An additional inquiry is can i do multiple cells that correlate to the PO "copied" i.e. If i Need to have PO, Salesperson, and Product rather than just the PO cell
This can be included in the above macro if needed. You'd just need to define what other ranges to copy and paste
alternatively are there any solutions that do not require macros
Not that I am aware of. If you have ~2500 rows of data you want to look at, then in your summary sheet you'd need ~2500 cells to look at each indervidual row to see whether or not there is a desired result, and then you'd have lots of gaps EG you may have data in C3:C10 and then a load of N/A's (or blanks if you use ISNA) until more data.
Unless someone else knows another way...a macro is the way to go
Bookmarks