Hey Mr. Excels,
I am currently running a project that requires an automation on data.
I have altogether 78 sheets:
- 3 sheets are output data.
- these 3 sheets are differentiated by payment types.
- the rest of the 75 sheets are category sheets
- category is located in J column in every sheet.
<colgroup><col span="12"><col><col><col><col span="4"></colgroup><tbody>
</tbody>
<colgroup><col span="11"><col><col><col><col span="4"></colgroup><tbody>
</tbody>
I am currently running a project that requires an automation on data.
I have altogether 78 sheets:
- 3 sheets are output data.
- these 3 sheets are differentiated by payment types.
- the rest of the 75 sheets are category sheets
- category is located in J column in every sheet.
ZIP/Postal Code | Country/Region | Salesperson | Region | Shipped Date | Shipper Name | Ship Name | Ship Address | Ship City | Ship State | Ship ZIP/Postal Code | Ship Country/Region | Payment Type | Product Name | Category | Unit Price | Quantity | Revenue | Shipping Fee |
99999 | USA | Mariya Sergienko | West | 12/29/14 | Shipping Company B | Karen Toh | 789 27th Street | Las Vegas | NV | 99999 | USA | Check | Beer | 1 | $14,00 | 19 | $266,00 | $25,80 |
99999 | USA | Mariya Sergienko | West | 12/29/14 | Shipping Company B | Karen Toh | 789 27th Street | Las Vegas | NV | 99999 | USA | Check | Dried Plums | 2 | $3,50 | 60 | $210,00 | $20,16 |
ZIP/Postal Code | Country/Region | Salesperson | Region | Shipped Date | Shipper Name | Ship Name | Ship Address | Ship City | Ship State | Ship ZIP/Postal Code | Ship Country/Region | Payment Type | Product Name | Category | Unit Price | Quantity | Revenue | Shipping Fee |
99999 | USA | Andrew Cencini | East | 12/06/14 | Shipping Company A | Christina Lee | 123 4th Street | New York | NY | 99999 | USA | Credit Card | Dried Pears | 3 | $30,00 | 81 | $2.430,00 | $255,15 |
99999 | USA | Andrew Cencini | East | 12/06/14 | Shipping Company A | Christina Lee | 123 4th Street | New York | NY | 99999 | USA | Credit Card | Dried Apples | 4 | $53,00 | 83 | $4.399,00 | $461,90 |
99999 | USA | Andrew Cencini | East | 12/06/14 | Shipping Company A | Christina Lee | 123 4th Street | New York | NY | 99999 | USA | Credit Card | Dried Plums | 5 | $3,50 | 75 | $262,50 | $26,25 |
99999 | USA | Mariya Sergienko | West | 12/14/14 | Shipping Company B | John Edwards | 123 12th Street | Las Vegas | NV | 99999 | USA | Credit Card | Chai | 6 | $18,00 | 97 | $1.746,00 | $183,33 |
99999 | USA | Mariya Sergienko | West | 12/14/14 | Shipping Company B | John Edwards | 123 12th Street | Las Vegas | NV | 99999 | USA | Credit Card | Coffee | 6 | $46,00 | 61 | $2.806,00 | $291,82 |
99999 | USA | Nancy Freehafer | North | 12/10/14 | Shipping Company C | Elizabeth Andersen | 123 8th Street | Portland | OR | 99999 | USA | Credit Card | Chocolate Biscuits Mix | 7 | $9,20 | 28 | $257,60 | $24,47 |
ZIP/Postal Code | Country/Region | Salesperson | Region | Shipped Date | Shipper Name | Ship Name | Ship Address | Ship City | Ship State | Ship ZIP/Postal Code | Ship Country/Region | Payment Type | Product Name | Category | Unit Price | Quantity | Revenue | Shipping Fee |
99999 | USA | Mariya Sergienko | West | 12/14/14 | Shipping Company B | John Edwards | 123 12th Street | Las Vegas | NV | 99999 | USA | Cash | 8 | $0,00 | $8,00 | |||
99999 | USA | Nancy Freehafer | North | 12/10/14 | Shipping Company C | Elizabeth Andersen | 123 8th Street | Portland | OR | 99999 | USA | Cash | Mozzarella | 9 | $34,80 | 29 | $2.923,20 | $300,85 |
99999 | USA | Andrew Cencini | East | 12/06/14 | Shipping Company C | Christina Lee | 123 4th Street | New York | NY | 99999 | USA | Cash | 12 | $0,00 | $9,00 | |||
99999 | USA | Jan Kotas | West | 12/31/14 | Shipping Company B | Soo Jung Lee | 789 29th Street | Denver | CO | 99999 | USA | Cash | 11 | $0,00 | $23,00 | |||
99999 | USA | Mariya Sergienko | West | 12/05/14 | Shipping Company B | Thomas Axerr | 123 3rd Street | Los Angelas | CA | 99999 | USA | Cash | Syrup | 11 | $10,00 | 49 | $280,00 | $90,25 |
99999 | USA | Mariya Sergienko | West | 12/05/14 | Shipping Company B | Thomas Axerr | 123 3rd Street | Los Angelas | CA | 99999 | USA | Cash | Curry Sauce | 15 | $40,00 | 29 | $480,00 | $239,12 |
<colgroup><col span="12"><col><col><col><col span="4"></colgroup><tbody>
</tbody>
I would like to have them transfer to the respective sheet by category. (All type 1 goes to overview category type 1 sheet); and track the changes whenever a new entry is recorded, all the sheets ( category type and the payment type sheet will be automatically update) Any inputs greatly appreciated. rgds, J. |
<colgroup><col span="11"><col><col><col><col span="4"></colgroup><tbody>
</tbody>