Hello everyone,
I'm looking for a macro that can do the following:
- I have a large file and I want to break it up into smaller workbooks based on the value in column H. (So everytime the value changes in column H, I would like a new workbook to be created, containing )
- I would like the smaller workbooks to retain the headers from row 1 of the original file
- I would like to save the files to a specific file path (they will all save to the same file path)
- I would also like the naming convention of the smaller files to be as follows: Value from Column H & " " & Date (in format mmddyy)
- These files should be in .xlsx format
Thank you so very much in advance for all your help!
Bookmarks