Hi Friends,
<tbody>
</tbody>
This is my sheet and i want to automate 3 tasks using VBA . Can someone please help me to do this .
1. Generate a summary page which displays sum of count against each product on column Related Product and Sum of Related Cost .
2. Split complete data to different work sheet on basis of column Invoiced At .
3. Highlight rows which has column QTY value less than 0.
key | Qty | Related Products | Related Cost | Invoiced at |
A | -1 | CAR | 100$ | Jan |
B | -1 | CAR | 150$ | Jan |
C | 0 | CAR | 170$ | Feb |
D | 1 | Bike | 50$ | Feb |
E | 1 | Bike | 40$ | Feb |
F | 1 | Cycle | 20$ | Mar |
<tbody>
</tbody>
This is my sheet and i want to automate 3 tasks using VBA . Can someone please help me to do this .
1. Generate a summary page which displays sum of count against each product on column Related Product and Sum of Related Cost .
2. Split complete data to different work sheet on basis of column Invoiced At .
3. Highlight rows which has column QTY value less than 0.
Last edited: