Hi,

I searched through forum and internet but all I could find is simple data validation or macro that select cells. I want it to be static, with drop down values within the macro itself, with ability to link that cell into formula. No new worksheet (there's one too many already) or data can be added in existing worksheets. Can someone help me with this?

Thank you in advance.

Regards,
dr