smowen
10-31-2007, 03:37 PM
In Excel I have a validation list which is made up of formulas taking values from another worksheet.
I want to have a macro which automatically sorts the list if a value within the list changes.
I tried using a worksheet_change macro, but this only works if the content of a cell changes and doesn't work with formulas.
Is there any way to do this?
Cheers
I want to have a macro which automatically sorts the list if a value within the list changes.
I tried using a worksheet_change macro, but this only works if the content of a cell changes and doesn't work with formulas.
Is there any way to do this?
Cheers