Automatically copy range of cells to cells on the same sheet

[toant]

Hi. I would sort by categories a range of cells to sub tables on the same sheet. I have attached a few pictures as examples to better explain my scenario. Please note "x" are just placeholders fields that some text will be entered later.

Criteria:

1) Automatically place each Item and range from Item==>Quantity it to each corresponding category "sub table" on the same sheet (i.e. all ice cream goes together and all Fruit goes together)
2) Any duplicate Items will not have another line but rather be combined and quantity added (note: highlighted quantity is just for reference that the quantity has been added)
3) If an Item is removed from the main table, it will automatically be removed from the sub table or substracted from the quantity.

Any help is appreciated. I would prefer not to use Macros for this.

Thank you in advance.


View attachment 41033

View attachment 41034
View attachment 41035

 

[Joe4]

Duplicate to: Automatically copy range of cells to cells of same sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.