Resume macro & Auto updating

[acerlaptop]

Hi guys,

I have a worksheet here that I've been working on. It has a loop that activates the dropdown menu then saves the file as pdf whenever the value in the dropdown changes.

What I want is to add a feature that will ask me if I want to resume or restart the whole processed when I click the button so that if ever the process was interrupted, I can continue again instead of restarting the whole process.

Also, in the worksheet named "2307", there is a field in there (Range M47:M56) that has a array formula. I want to use macro in that part instead of array formula. What it does is it extracts unique value from worksheet "DATA" column name "ATC" based on a criteria which is to index value of worksheet "2307" range "A1" to worksheet "DATA" range "A:A". Also, range M47:M56 only has 10 rows, so if ever the unique values surpass 10 items, the macro will add additional rows depending on the need then delete it again on the next loop so that the default rows remains M47:M56.