I have created a worksheet to track project status each month. (copy attached) Currently I have drop down lists to select the appropriate status symbol. There are four options. Problem is that my 'Key' now contains symbols and letters. Can I create a macro to copy from the key and paste into the selected cell each month? (instead of using a drop down list)
Best Regards,
Joanne
Bookmarks