Automate Order & EAN Consolidation
Budget: €30 – €250 EUR
We have an Excel workbook that contains:
Worksheet 1: An order form where users enter product orders.
Worksheet 2: A product details list containing additional information about each product.
We need to automate the process so that when someone fills out the order form, specific data from Worksheet 1 and Worksheet 2 is automatically combined and exported to Worksheet 3. In Worksheet 3, the data should be restructured and formatted according to a predefined system or layout.
Worksheet 1: An order form where users enter product orders.
Worksheet 2: A product details list containing additional information about each product.
We need to automate the process so that when someone fills out the order form, specific data from Worksheet 1 and Worksheet 2 is automatically combined and exported to Worksheet 3. In Worksheet 3, the data should be restructured and formatted according to a predefined system or layout.