Hello everyone,
WIll try to explain this as best as I can
Starting at A1
Row 1 is conditional row for the code
<tbody>
</tbody>What I wish for is in other sheet rows from column A to be moved (not copied) by matching criteria from cell A1, added in column B value from B1, in Column C total counts moved of items in column A matching value in C
So lets say top table has been added twice to the sheet with same criteria
Starting at a1
<tbody>
</tbody>
If after that criteria changes to ex.
Mark and 22
and
Steve and 40
<tbody>
</tbody>
And in next rows all new moved values would be filled
I hope I didn't miss anything and it's all clear
Thank you
WIll try to explain this as best as I can
Starting at A1
Row 1 is conditional row for the code
John | 22 |
Apple | John |
Apple | Mark |
Cup | John |
Cup | Mark |
Apple | Steve |
Pen | Mark |
etc | etc |
etc | etc |
etc | etc |
<tbody>
</tbody>
So lets say top table has been added twice to the sheet with same criteria
Starting at a1
Apple | 22 | 2 | |
Cup | 22 | 2 | |
<tbody>
</tbody>
If after that criteria changes to ex.
Mark and 22
and
Steve and 40
Apple | 22 | 3 |
Cup | 22 | 3 |
Pen | 22 | 1 |
Apple | 40 | 1 |
<tbody>
</tbody>
And in next rows all new moved values would be filled
I hope I didn't miss anything and it's all clear
Thank you