Attached I have a spreadsheet with a user form to capture orders.
I have got the form working as far as, each piece of data will go into the right column heading. However because one customer will order multiple items I cannot work out how to get the items to list in one column a row at a time.
My idea is that each multipage and all the data entered (zero if blank) will be dumped into the spreadsheet in its rightful column in a list as displayed in the form, as each value in the list represents the weight band aligned to it.
Maybe I cannot do it as it is currently set up, so any other ideas/suggestions welcome.
Thanks
Bookmarks