Create Multiple New Files from Master Sheet

Good day - thanks in advance for your time. I'll be attaching a sample worksheet to help with what I'm probably not describing too clearly.

I have a "master" file that needs to be parsed into multiple other files. The number of other files will vary daily, but I've identified the file number in Column A. So if on Monday there are only 3 files, the numbers in column A won't exceed 3.

What I need to do is create and save 3 (or however many) new files containing ONLY the rows from the master with the associated file number in Column A. The filenames will be similar, but not the same, but I can set that up as a variable.

I've tried using auto filter, and changing the values being read, but I can't reliably catch the correct file number from the top visible row.

Can anybody lend me a hand?

THANK YOU!!!!

Humdingaling - thank you so much for getting back to me. I apologize for the delay in response, but was called out of town somewhat unexpectedly and had no access to a pc.

The autofiltering is great, and I certainly appreciate it. I think I can find code to copy the filtered values, create a new workbook, paste the results, then save to a repository and close. Once I get those things to work I'll be all set.

Thank you again!

Thanks again for your help...did a little tweaking and added some code for the saveas and I have what appears to work.

Please Login or Register  to view this content.

Ah, thank you for the reminder about the Data Validation box... and for the rows.count correction. I generally don't hard code a number in there like that, but often do so as a placeholder while I'm writing/testing and just forgot to replace it. I know, it's easier to write rows.count, but old habits die hard I suppose!
Anyway, thank you again for your help!