Find and replace into new rows using excel macro

[rohan_excel]

Hi Team,

I would completely new to excel macros, and i would like to know as to how the below could be implemented
Any help is much appreciated.

1) The below is a template as to how my cases are supposed to be

2 ) This is the data set from which the data is to be fetched and populated

3 ) The below is the outcome which is how i'd like it to be

 

[hiker95]

rohan_excel,

Welcome to the MrExcel forum.


We can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[rohan_excel]

Hi Team,

Apologies,

Please find the link to my excel file : https://www.dropbox.com/s/d6ndxk75n60zj1h/Template.xlsx?dl=0

Ideally, in Sheet1 I have the template, and in sheet2 i have the data that has to be parameterized.

Back in sheet1, the expected result is how I'd like to final outcome to be

Thanks,
Rohan

 

[hiker95]

rohan_excel,

Thanks for the workbook/worksheets.

Can we have another workbook/worksheet that just displays what Sheet1 looks like without the data from Sheet2?

 

[rohan_excel]

Hi Hiker95

That should be from A2:D4, Please find the link below for the file

https://www.dropbox.com/s/609drgh0fwbpvw6/Template_Updated.xlsx?dl=0

 

[hiker95]

rohan_excel,

I have looked at the two workbooks, and, can not see the logic to solve your request.

Maybe someone else on MrExcel will be able to help you.