Hi there! I don't even know if this is possible, but I could really use some help with a macro. I need it to copy and paste data from Workbook 1 into a new workbook (workbook 2) but in the process to loop and filter through everything in column A, then copy all of the filtered data into a new workbooks and save it with a file name based on the data in workbook 1 (cell A2). If possible can it also delete the entire A column in workbook 2 prior to saving?
Pet Owner Pick up date Pet Tag
Bob 1/19/2016 213
Jerry 1/20/2016 215
Tom 1/21/2016 213
Amy 1/22/2016 213
Mike 1/23/2016 213
Bob 1/24/2016 213
So in the above example, the macro would filter Bob, create a new worksheet and save it as "bob.xls" but the data in the worksheet would only have pick up date and pet tag, then it would look and create a new worksheet, save it as Jerry but the data would only have pick up date and pet tag... repeat so on and so on...
Bookmarks