Dynamic sheet

Copper Contributor
I’m making a sale and service offer with excel (I used your XLOOKUP video and Multiple Drop box), but it is working for 1 single unit (there is one equipment and several accessories), but when I have to sell more units or service more units, this is not working, unless I add manually more tables.

Now, my question is:
IS IT POSSIBLE TO MAKE A MASK/FORM WHERE I CAN CHOOSE THE DIFFERENT EXCEL SHEETS OR ADDING TABLES AUTOMATICALLY DEPENDING ON THE NUMBER OF THE UNITS?
3 Replies
please share your workbook
Here it is
No it's not. And please be sure that there's no confidential or proprietary data in the workbook.