Hello,
I have a very complicated task (at least complicated to me) I love figuring out excel issues however I do not know how to tackle this one. please help...
here is what I am trying to do. I am creating a template for my accounting department to use for our invoices. there is a lot of complicated stuff I will need help with but the first thing is this.
I will have a spot for item description
another spot that has a drop-down menu for Quantity (1-100)
another spot that askes if items are serialized with a drop-down menu (yes-no) yes/no drop down box will be changed to a combo box
upon completing each field and if s/n =yes, then I need a box to pop up (name of the box is what was put in the Item (brief desc) field, then the amount of cells in the box is the (amount selected in Quantity drop-down menu.)
this will allow accounting to put the proper amount of serial numbers in the field. after they put the s/n's in the field I would need an ok button that will auto-populate another tab to store s/n's with the same header and amount of cells as the popup box. later this will all auto-populate in an invoice template. but for now, I just need help with this box
I don't know if this is easier or harder than I think but it sounds super complicated to me and I just can not figure it out.
thank you in advance for any advice and help!
On attachment, the area I am working on right now is the Product information section.
changes already suggested that I plan to make:
1. no merged cells
2. yes/no drop down box will be changed to a combo box
Bookmarks