Hello all.
I am a complete excel noob and do not even know where to begin with my problem. I took some pictures wot try to fill in the info. Basically what I have is a set of tables on one sheet with info (outlined in thick green) that I would like to be able to auto populate in the template (picture with thin green border) all at one time. Ideally I would like for this to occur via a combo box (or dropdown) that I can just select a table name and have the data appear. I have presented two charts as examples, but will eventually have many more, and I would like for them to be able to populate the cells in each of the three boxes interchangeably. I have seen templates such as mine where people do this, but have not been able to figure it out on my own. I have used vlookup for many other things in this workbook and ,as such, have tried using it here, but only successfully getting it to work for one row (which makes sense). I attempted to use index match and managed to get one table to work, but it took a ton of formatting on the template side and could not get multiple tables to work in the same drop down menu.
Any advice is appreciated!
Screen Shot 2019-04-09 at 7.21.59 PM.png
Screen Shot 2019-04-09 at 7.21.05 PM.png
Bookmarks