Dynamic sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2744770%22%20slang%3D%22en-US%22%3EDynamic%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744770%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20making%20a%20sale%20and%20service%20offer%20with%20excel%20(I%20used%20your%20XLOOKUP%20video%20and%20Multiple%20Drop%20box)%2C%20but%20it%20is%20working%20for%201%20single%20unit%20(there%20is%20one%20equipment%20and%20several%20accessories)%2C%20but%20when%20I%20have%20to%20sell%20more%20units%20or%20service%20more%20units%2C%20this%20is%20not%20working%2C%20unless%20I%20add%20manually%20more%20tables.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%2C%20my%20question%20is%3A%3CBR%20%2F%3EIS%20IT%20POSSIBLE%20TO%20MAKE%20A%20MASK%2FFORM%20WHERE%20I%20CAN%20CHOOSE%20THE%20DIFFERENT%20EXCEL%20SHEETS%20OR%20ADDING%20TABLES%20AUTOMATICALLY%20DEPENDING%20ON%20THE%20NUMBER%20OF%20THE%20UNITS%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2744770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2752421%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752421%22%20slang%3D%22en-US%22%3Eplease%20share%20your%20workbook%3C%2FLINGO-BODY%3E
New 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.