Hello, I am hoping you can help with some VBA code to move some matching data.
My criteria is as follows:
1. Look in column 2 starting from row 3 for cells that contain letter "P" as anywhere in cell value
2. Look in Column 3 and 4 starting from row 3 for cells that do NOT contain "Red", "Green", "Blue" or "Green" anywhere in cell value
3. Look in Column 10 starting from row 3 for any value above 15
I need to copy the matching rows to workbook C:\temp\Master.xlsm, Sheet "NewData" starting in cell A3, in order of Columns 1,2,3,4,8,5,10,12.
Many thanks!