Quote Originally Posted by mosswood17 View Post
The other idea I just had is whether there is a way to generate that criteria statement based on input from another cell. If I enter "MOR" in cell A1, can I get Excel to generate ="=MOR" in cell A2? I think this would work too, and probably be a lot easier. Thanks!
I just figured it out!!!!!!!!! The line I am using is: ="="&A5. By concatenating the text I can change it to whatever the target cell is updating my criteria whenever a new drug is chosen! Thanks so much for your help! I really love working with Excel! Someday I will figure out Macros, but this place looks to be the place to do that.