Okay I am stuck at work trying to get something together. I am not an excel master as I just mostly do data entry/formatting.
My problem: I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:
If Target.Address = "$F$3" Then
Target.Offset(0, 1).Value = "1"
but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.
Some insight would be greatly appreciated. I don't really want to attach the worksheet as the information on it I am bound by contract not to share.
Thanks,
Ryan
Bookmarks