Hello - hoping some one can help me!
Im recording a macro that goes into another workbook applys an autofilter and copies and pastes the results into the original workbook.
Windows("FTE Database.xls").Activate
Selection.AutoFilter Field:=12, Criteria1:="Bob Jones"
Range("A891:C1197").Select
Selection.Copy
Windows("Collector").Activate
Range("B7").Select
ActiveSheet.Paste
Range("B7:D26").Select
Application.CutCopyMode = False
Is there anyway i can make the criteria link to Text in a Cell? I.E. instead of manually selecting Bob Jones, i want to macro to autofilter to the text in cell "T5" in the "Collector" workbook
Thanks,
Bookmarks