Hi,
Reg No. is the no. by vich i save the order. Its just like the order number.(But the order number is given by the companies who give me order while reg no. is the no. by vich my company saves the order.)
I have a chemical manufacturin company. the orders vich I get are mostly scanned copies of documents or sometimes even handwritten copies sent through whatsapp/email etc..Many orders have more than 100 products listed. Typin all of them is much time consuming. So instead of typin, I created a listbox of all the products and now I just have to select the products and extract it to 'A" column of the sheet and enter remaining data.. (Then I use barcode to pack the ordered products and create bill using a macro to get name address and other general info from the 'order' sheet and the packed products from barcode sheet. But dis part is workin fine so I havent attached those sheets here.) Its the listbox part I am havin trouble with. I can attach entire file if needed.
Btw, my name is Taral![]()
Bookmarks