Auto populate adjacent cells based on specific dropdown selection

Hello,

The issue I'm trying to resolve involves how to autopopulate adjacent cells with certain text if a certain item is selected from a dropdown menu in another column. Obviously this can easily be done with formulas and whatnot, but there is a catch that I cannot seem to work around. In the cell with the dropdown menu, there are 5 selections to choose from. For one of the selections, titled "No Current Yr", I want several adjacent cells in the same row to auto populate with an asterisk (*). If any of the other four selections are chosen from the dropdown menu, I want to be able to enter data directly into the adjacent cells that would otherwise be populated with the asterisk.

So for example, Q3 has a dropdown menu with the 5 options. If "No Current Yr" is selected from the dropdown menu, I want F3:I3,K3:N3, and P3 to autopopulate with the asterisk. For any of the other 4 selections from the dropdown in Q3, I want to be able to enter data manually into those cells. The same goes for Q4 autopopulating F4:I4,K4:N4, and P4 etc. etc. all the way down to row 92. That is, I want the selection in column Q for a given row to autopopulate the above referenced cells in its same row, for each row between 3 and 92.

Is there any way to make this happen?

Thank you!

This worked absolutely perfectly! Thanks so much for the help.

So I may have jumped the gun on this one... When I first tested the code, I did it in a worksheet that had no other code on it and it worked perfectly. Now I'm trying to place in into a worksheet that has other code in it already and it's not working. The target cells and ranges are all the same for this worksheet, but it doesn't seem to execute. Any thoughts?

Hi millz,

I literally just figured out the problem after working through it. I'm pretty well versed in Excel but quite new to VBA. It was a matter of putting the macros in the correct place so they weren't conflicting with one another. It's been a lot of learning on-the-go, but I suppose that's half the fun. Anyway, problem solved. Thanks again!