I supply alcohol to Hotels & Bars (these are my clients).
I provide them with an excel workbook known as the OrderForm. It contains many different products (9000) spilt into categories then brand, in a list format.
The client travels thru the workbook adding quantities of how many they require that week.
I’d like to create an Order Acknowledgement Form on a seperate Worksheet within the workbook, where it summarises what they have ordered from the different worksheets.
Please can someone help me?