I'm looking to automate a process, but, am a newbie to VBA. In worksheet one I'm trying to create a "tracker" which will have grey cells and white cells based on decisions (worksheet 1). All decisions have been pulled and put into a pivot table (worksheet 2).
The keys I'm thinking to help with this process are matching of the clients name on worksheet 1 which are C5:CE5. Clients name are also listed in worksheet 2 A12:A55.
The other key and this is where I'm having the most challenge is on metallic levels. For worksheet 1 this information is found A6:A340 which lists out various metallics (xyz bronze, or zzz platinum alt). For worksheet 2 this information has been provided as a "sum" with B11:I11 listing metallic and B12:I55 proving a "1" if the metallic is selected or blank if it has not been selected.
If a client elected a certain metallic the cell should stay white. If it was not elected the cell should be gray. Attached is sample along w/a tab on how it should look when completed. Appreciate any help you can provide to help me get started.
The only options that can be chosen are:
Bronze Plus Alt
Silver Alt I
Silver Alt II
Thanks again in advanced.