I have an excel workbook that has 21 worksheets. There is one chart or table on each of these sheets. These charts/tables represent data from 3 different stores. The first 7 are for the uptown store, the 2nd 7 are for the midtown store and the last 7 are for the downtown store.
I have 3 powerpoint files, one for each store, that have their respective 7 charts from excel linked to them. This works fine for now but i'm going to have to add 15 new stores with 7 slides each. I don't want to have to make 15 more ppt files and link the proper worksheets to them. I'd rather have one ppt file that somehow links the proper worksheets/charts to it with code. I'd like to make an interface in excel to choose the name of the store and then have it build the report (7 slide ppt file) automatically.
Any help is greatly appreciated. Thank you