Good day
I am trying to create and update a unique list whenever the source data is changed. I have read some threads to make the list for a combo box and using formulas. My problem is I need to run a vba as people will be working with the sheet that don't understand excel all to well.
So this is what I want:
I have a list in Column E called "Grade" in a sheet called "Recovery CCW", this column will be continuously updated.
I want to return a list of unique vales from Column E on the "Recovery CCW" sheet to Cell A2 in a sheet called "Calculation sheet"
I found some functions that will work if you run the macro manually but I am a bit of a noob at changing it to dynamically update.
Your help will be much appreciated.
Thanks, have a great day