Hello,
I'm looking for a solution for my case.
Right now I have a file with 2 sheets where I have similar data.
In first sheet I have a Raw Data with all the food which restaurant sold and what components were used to create the dish:
I need to match the data from second sheet (screen below) based on "Component" column and add below missing rows with data what exactly was used to create the "Dip"
Basically, the macro should be able to match the data based on column B+A and copy below each food in sheet 1 all components which were used to do it.
My expectation is to get outcome as on screen below.
I'm looking for a solution for my case.
Right now I have a file with 2 sheets where I have similar data.
In first sheet I have a Raw Data with all the food which restaurant sold and what components were used to create the dish:
I need to match the data from second sheet (screen below) based on "Component" column and add below missing rows with data what exactly was used to create the "Dip"
Basically, the macro should be able to match the data based on column B+A and copy below each food in sheet 1 all components which were used to do it.
My expectation is to get outcome as on screen below.