How to replace a row in Sheet 1 with rows in Sheet 2 and Sheet 3 based on an identifier?

Copper Contributor
Spoiler
In the attached excel file:

There are 2 sheets created, sheet 2 and sheet 3 with rows of data, and I want to create a macro to replace the original entry in "list orders export" with the two rows from sheet2 and sheet3 respectively -

For ex, in this example excel, UBS Switzerland AG entry in "List Orders export" sheet should be replaced by the two rows, one from Sheet2 and one from Sheet3 based on the name "UBS Switzerland AG"

 

so the original row in the "list order export" sheet should be gone and instead the two rows from sheet 2 and 3 are there to replace it. How can I do this?

0 Replies