ONLY FOR EXPERT EXCEL USER
Refer -> Attached file
Refer -> tabsheet "summary", refer to "row 1" coloumn "s to x" ->accessories summary.
Refer -> tabsheet "Master", "Master (2)" and "Master (3)" ->"accessories" table (C=25,R=B to F)
Required to pull data from masters sheet to summary sheet accessories and gives a consolidated
data of Description and Qty. (pcs) "Accessories"of master sheets into summary sheet.
Please note that master sheet data changes with change in C2 dropdown of master sheets.
The consolidated data should also change with this changes. For example - you may refer to
Screenkit Summary and Profile Summary in summary tabsheet.
You may apply formula or macros to get the result - It's upon you.
Once you prove that this is doable, you'll be selected for this project.
Final project would consist of 50 tabsheets (masters) and would require the similar result
in "summary" sheet. Can you?