Hi,
Please help!
I have a worksheet where in a row I will have a date (column A), a trailer number (column B), a store number (Column C) and a number of loaded cages displayed (Column D).
In column A the same date might be used multiple times. In column G I have a macro running automatically to fetch unique data from this column A every time something added or removed.
Column B (trailer numbers): each day there are 2 different trailer numbers loaded with different stores. These trailer numbers are recorder multiple times as well as each day each trailer has multiple stores loaded on them with different amount of cages.
On the same sheet I have a summary area, starting with column G. Here I have each date displayed only once, and I need to fetch a sum value for the first and the second trailer separately into columns H and I for that day.
E.g.
<tbody>
</tbody>
I've tried so many different things (like =sumifs which works well for the first date but can't modify it for the rest of the data) but nothing seemed to work. I am really not good with VBA, but seems like this is too complex to have any other solution?
If any ideas, can you please spell it out to me as much as possible? I haven't done super complex things with excel before, and defo nothing google could not help me with, so I feel like a noob with this one...
Thank you!
Eva
Please help!
I have a worksheet where in a row I will have a date (column A), a trailer number (column B), a store number (Column C) and a number of loaded cages displayed (Column D).
In column A the same date might be used multiple times. In column G I have a macro running automatically to fetch unique data from this column A every time something added or removed.
Column B (trailer numbers): each day there are 2 different trailer numbers loaded with different stores. These trailer numbers are recorder multiple times as well as each day each trailer has multiple stores loaded on them with different amount of cages.
On the same sheet I have a summary area, starting with column G. Here I have each date displayed only once, and I need to fetch a sum value for the first and the second trailer separately into columns H and I for that day.
E.g.
Date | Trailer | Store | Amount | Date | Amount on trl1 | Amount on trl2 | |
30/05/2018 | TRL21 | 11 | 4 | 30/05/2018 | need to show 13 for trl21 | need to show 14 for trl18 | |
30/05/2018 | TRL21 | 47 | 5 | 31/05/2018 | need to show 23 for trl08 | need to show 15 for trl65 | |
30/05/2018 | TRL21 | 74 | 4 | ||||
30/05/2018 | TRL18 | 21 | 11 | ||||
30/05/2018 | TRL18 | 18 | 3 | ||||
31/05/2018 | TRL08 | 9 | 9 | ||||
31/05/2018 | TRL08 | 36 | 8 | ||||
31/05/2018 | TRL08 | 24 | 6 | ||||
31/05/2018 | TRL65 | 85 | 14 | ||||
31/05/2018 | TRL65 | 16 | 1 |
<tbody>
</tbody>
I've tried so many different things (like =sumifs which works well for the first date but can't modify it for the rest of the data) but nothing seemed to work. I am really not good with VBA, but seems like this is too complex to have any other solution?
If any ideas, can you please spell it out to me as much as possible? I haven't done super complex things with excel before, and defo nothing google could not help me with, so I feel like a noob with this one...
Thank you!
Eva