Vba inquiry with duplicate rowd

[Noxas]

Hey everyone,

I’ve been struggling with this macro for some time now and nothing I’ve tried seems to be working. I have an excel with several rows of data. I require, based on the data in column A, to be duplicated. I then require the data in column d to replace the data in column b in these new rows.

Below is an example. Thank you in advance

 

[StephenCrump]

Welcome to the Forum!

What output do you expect to see for the example posted?

Does the solution need to be VBA?

 

[Noxas]

Hey everyone,

I’ve been struggling with this macro for some time now and nothing I’ve tried seems to be working. I have an excel with several rows of data. I require, based on the data in column A, to be duplicated. I then require the data in column d to replace the data in column b in these new rows.

Below is an example. Thank you in advance

Ah my example is not that great. So I would expect a duplicate of data 3 and with the data in column c replacing the data in column b in this new data.

I’m writing up a macro and this is the only part I can’t seem to get to work; everything else is in vba

 

[Noxas]

Ah my example is not that great. So I would expect a duplicate of data 3 and with the data in column c replacing the data in column b in this new data.

I’m writing up a macro and this is the only part I can’t seem to get to work; everything else is in vba

Apologies. I meant the data in column D would replace the data in column b in this new data.

 

[StephenCrump]

Can you please show us the expected output?

And you haven't answered this question:

Does the solution need to be VBA?

 

[Noxas]

Can you please show us the expected output?

And you haven't answered this question:

Yes it would need to be in vba. The highlighted in red would be the expected output

 

[StephenCrump]

What happened to the Data 2 and Data 3 lines?

Can you please show separately:

1. All input cells
2. All required output cells

 

[Noxas]

What happened to the Data 2 and Data 3 lines?

Can you please show separately:

1. All input cells
2. All required output cells

I’m slightly confused. I would need the code to search specifically for Data 1 and duplicate these lines. Data 2 and data 3 would be ignored. First picture is the base set of data. Second photo is the second set of data I would need the vba to duplicate and modify based on the base set of data. Hopefully this makes sense.

 

[StephenCrump]

I know you want VBA, but just to be clear, does this formula give you the results you want (when you change cell B8)?

	A	B	C	D
1	Input
2	Data 1	Info 1	123	Apple
3	Data 1	Info 1	456	Eggs
4	Data 2	Info 2	789	Banana
5	Data 2	Info 2	101112	Orange
6	Data 3	Info 3	131415	Peach
7
8	Output	Data 2
9	Data 2	Banana	789	Banana
10	Data 2	Orange	101112	Orange
11
Sheet1

Cell Formulas
Range	Formula
A9:D10	A9	=CHOOSECOLS(FILTER(A2:D6,A2:A6=B8),{1,4,3,4})
Dynamic array formulas.

 

[Joe4]

Noxas,

Please do not mark a post as the solution if it does not actually contain the solution.
I have removed that designation.