I just learned how to to link to a graphic that I can change by clicking the associated customer in a drop down menu. The creator of the formula outlined how to create a Dropdown with validation list then a Named range, so this gave me an idea.
What I have is a workbook with multiple worksheets. The first worksheet is always a Reference, the remaining worksheets are labeled for each customer accounts. Each of these customer account worksheets are set up the same with the same column headers, row headers and basic format. Within the cells is the data that pertains just to that customer (product, pricing, dates of programs, etc.).
I'd like to have a worksheet be utilized as a 'Handout' that I customize when I am working on a particular day with certain customers. For instance, if I am going to be working with CustomerA for the day, I'd like to be able to use the Handout worksheet, click a dropdown menu within choosing the CustomerA worksheet and the Handout could fill in certain cells with data from the CustomerA worksheet. I know I can do VLookup for various cells but I'm wondering if I can have a blanket VLookup activate for multiple cells? I always create worksheets with a column at the beginning for a common product item number. Out of 1000 product numbers, different customers use different ones so the product information could fill in by referencing this.
If it helps to create a test workbook, please let know and I'll do this.
Bookmarks