I really need your help for the following situation.
" Row 1 - 4 is the titles. Column Y has multiple different criteria.
What I want to do is: 1. Filter column Y to see the first criteria. 2. Copy from row 1 to the last used row, and column A-X. 3. Save it as a new workbook. Name it exactly like column Y criteria. I have the File path on Sheets("Detail").Range("D17"). (Cell D17 has a path like this: C:\Users\Aiden\Desktop.......................) 4. Close the new workbook 5. Go back to the main file. filter column Y for next criteria. 6. Copy..save as new workbook....keep going until we loop thru all criteria on column Y.
Can someone please help me with this?