On Save, Calculate to Restore Formulas is modified. And a add totals of unique values.

Hi,

This is where I am at currently with this.

1. I tried this macro combo from another project I had back in the day, but its not working and not quite sure where I am messing up at.

Macro in the sheet

Please Login or Register  to view this content.

Then in a module

Please Login or Register  to view this content.

I want column "TM in Process Where Made" and "Cost Calculator" to calculate the formulas back in on save.

2. [SOLVED] I went with a formula of

Please Login or Register  to view this content.

instead with a countif formula in the next column.

Any help would be appreciated .

Thank you.

I have made progress with this, but ran into a problem and not sure why. So I accomplished my task with the "TM in Process Where Made" column, but only when SelectionChange is the option for the worksheet. I want it the macro to activate when the file is saved to limited issues. Hoping to get the macro below to work in column J "TM in Process Where Made" when the file is saved. Thank you.

Please Login or Register  to view this content.

I have been able to make this work for me. This is the macro I came up with, this is here to help anyone with a similar situation.

Please Login or Register  to view this content.