Macro works....but CRASHES!

Hi everyone,

I've been using this site for YEARS; it's been a GODSEND! I've always been able to find my answer by searching. I finally had to register to ask a question (:

I have a macro that does many things - it takes data from the active workbook and creates a new workbook for each unique value. But it also asks which column to use for the sort (because incoming worksheets are different), asks for the range, asks for the storage location, and renames the new workbooks based on the sort criteria and active workbook's name.

I'm loathe to mess with the macro because it does so many things.....but it also crashes my computer EVERY time I run it.

My goal is to take multiple reports received every month (that have varying formats and data) and break them up into individual workbooks based on the one column of values (the item code) they will all have in common.

Please forgive if I've attached the excel file incorrectly? I tried to imbed the code but it was too long.

If you could look at this and let me know if it's possible to streamline it to stop it from crashing my computer, that would be wonderful.

Thanks in advance!Macro.xlsm

Does the crashing happens only after asking all those questions you have mentioned?

Could be because of this line:

Please Login or Register  to view this content.

Seems like it's trying to open the folder where the workbook is saved to. Try commenting this line out and run the macro again, does it still crash your computer?

Thank you for taking the time to look at this! I appreciate your help!

I did as suggested and deleted the line...no luck, still works but still crashes.