Customer Order Worksheet:
Customer selects their choices of exterior color, interior color, and trim package for product in cells (B3,C3,D3) of their order form. Cell (E3) formula compiles three selections into one number. Customer writes phone and address in cells (E4) and (E5).
Can use MATCH to find customer selections matching options listed in Order Processing Worksheet below (C17:BN17), but then need to somehow? add that customer's order (one to customer) to the tabulation of orders for products with that set of options in appropriate cell below (C18:BN18).
Then need help to place customer's address from order worksheet into processing worksheet in next available cell below where new order was tabulated.
Any help, discussion, suggestions appreciated.
Bookmarks