I'm hoping someone can help me figure out how to code some functions that are a little beyond my abilities. What I'm trying to do is b able to click command buttons and have Excel determine where to place letters on the workbook based on what is selected in the combobox.
So for example, if I choose 710300A, that SKU on the workbook is in cell C3. Start (S). Finished (F). Published (P).
So if I click 360 Start while the Product SKU has 710300A selected, an "S would appear in cell E3. If I clicked Reviews Finalized, an "F" would appear in cell I3.
If I changed the ProductSKU selection to 708287A, located in cell C14 on the worksheet and clicked 360 Start, Excel would know to place an "S" in cell E14.
I've attached the workbook I have so far, as well as an image reiterating this scenario.
Thank you for any help you can provide!!
Bookmarks