Hi,
I have a table that shows products that need to be matched to a set criteria and then pasted into a new table appended. The example below shows the desired result in D&E.
When a product (A) has an action (B) to 'Exclude COS', I want to paste appended the Product & the Macro Area listed in (G) 'STORES COS' to D&E.
When a Product has and action 'Exclude all' I want to paste the product and a repeated row, listing all Macro areas, again appended to D&E.
The 'list of Macro areas' does not need to be a list and can be coded if needed.
I have spent a couple of hours trying to work this out and watching various videos but have not managed it.
Thanks for any help given!
Plex.
I have a table that shows products that need to be matched to a set criteria and then pasted into a new table appended. The example below shows the desired result in D&E.
When a product (A) has an action (B) to 'Exclude COS', I want to paste appended the Product & the Macro Area listed in (G) 'STORES COS' to D&E.
When a Product has and action 'Exclude all' I want to paste the product and a repeated row, listing all Macro areas, again appended to D&E.
The 'list of Macro areas' does not need to be a list and can be coded if needed.
A | B | D | E | G | ||
SKU | Action? | SKU | Macro Area | List of Macro areas | ||
AALCMSCN | Exclude All | AALENTEN | STORES COS | STORES COS | ||
AALENTEN | Exclude COS | AALCMSCN | STORES COS | SMB | ||
AALCMSCN | SMB | Enterprise | ||||
AALCMSCN | Enterprise | Online | ||||
AALCMSCN | Online |
I have spent a couple of hours trying to work this out and watching various videos but have not managed it.
Thanks for any help given!
Plex.