VBA shipping order form

**decolit** · 05-12-2021, 02:30 PM

Hello Everybody,

I need to create an order shipping form that would run under Excel 2019 as follows :

A - in a given Excel file, an order list is created in worksheet 2 which contains :
- in column A : the customer order reference ,
- in column B : the customer name,
- in column C : the item quantity, for each customer. This value is an integer.

A customer can place several orders, and thus there may be several order references for one given customer.

B - the "user interface" is displayed in worksheet 1 of same Excel file. On this worksheet 1, the following data will appear :
- in A1 (for example) : the corresponding customer order reference from worksheet 2,
- in B1 : the customer name,
- in C1 : the "order basket" containing the item codes (either typed in or scanned) corresponding to the customer basket. These codes are alphanumeric strings, separated by a comma. These strings will never exceed 30 digit length.

For each order reference, when the number of the item codes is equal to the quantity set in worksheet 1, then the basket is emptied and a line is created in a worksheet 3, storing the order reference in column A and the items code in column B. The basket is ready for the next order reference.

A counter somewhere in worksheet 1 displays the number of the order reference being currently processed : there can be as many as 1500 lines and I would like to see 125/1500 for example.

C - after processing all the lines of worksheet 2, the worksheet 3 is automatically named "orders XXX 2021.05.12". Worksheet 3 contains in column A the order references, and the corresponding items codes separated by a comma, in one cell, for each order reference.

To make worksheet 1 more user friendly, I would like to see the customer order reference and customer name as big as possible as well as the "basket" displaying the scanned or typed items codes.

I am really sorry not being able to describe in a more synthetic way my problem, but I am not familiar with code specification.

I have tried to solve with formulas, but I really think that VBA would help tackle the question in a very effective and much elegant way. Unfortunately, it's simply beyond my command.

Thank you in advance for your time and understanding.

Merci beaucoup

**maniacb** · 05-12-2021, 02:40 PM

It would be of great assistance to see a sample file of your work so that we can recommend a solution. Follow the instructions in the yellow banner above.