If and Else If to Insert Rows basis various Conditions

[VBAEnjoi]

Hello,

I have a Column with 1, 2 and 3. The number of 1s, 2s and 3s can vary.
Also there are 6 combination Options in which they can appear, grid below.
I need to insert Rows after last 1 and last 2. If the result is only 3 Option F
below I need to proceed with the next step.

Options	1	2	3
A	Yes	Yes	Yes
B	Yes	Yes	No
C	Yes	No	No
D	No	Yes	Yes
E	No	Yes	No
F	No	No	Yes

<tbody>
</tbody>

Tried using If, Then and ElseIf however it stops at the first condition if that is not met.

 

[oldbrewer]

I need to insert Rows after last 1 and last 2

you have 6 rows at present - when do you want to insert another row - and if it is the last row you are populating a row, not inserting it - are you creating combinations ?

 

[VBAEnjoi]

Hello

I have dynamic number of rows. Each of them could have either value 1,2 or 3. In the below e.g. I would like to insert row at A4 and A6

A1 = 1
A2 = 1
A3 = 1
A4 = 2
A5 = 2
A6 = 3

 

[oldbrewer]

1		101
1		102
1		103
2			204
2			205
3
		where there is a 1 then 100 plus row number
		where there is a 2 then 200 plus row number
		=large(C1:C10,1) finds 103
		say the 103 is in J1 then K1 is J1 minus 100 plus 1 then a macro can use that
		cells(1,11).select
		code to insert new row
		repeat for col D

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[VBAEnjoi]

Hi do you want me to add new columns?
Can I not do it in the same column and a simpler code

1		101
1		102
1		103
2			204
2			205
3
		where there is a 1 then 100 plus row number
		where there is a 2 then 200 plus row number
		=large(C1:C10,1) finds 103
		say the 103 is in J1 then K1 is J1 minus 100 plus 1 then a macro can use that
		cells(1,11).select
		code to insert new row
		repeat for col D

<tbody>
</tbody>

 

[oldbrewer]

you cannot insert a row with a formula - you need a macro

 

[VBAEnjoi]

I need a macro. I need to know how to provide the If Then Else Condition with the above 6 combinations

 

[VBAEnjoi]

Hello - Await your revert. Thanks. Listing below the possible options.
Don't go with the A,B, C etc. listed earlier.

A	B	C	D	E	F	G
1	1	1	1	2	2	3
1	1	1	1	2	2	3
1	1	2	1	2	2	3
2		2	1	2	2	3
2		2	3	3
2			3	3
3
3

<tbody>
</tbody>

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

can you redefine what you want, please ?

 

[VBAEnjoi]

A	B	C	D	E	F	G
1	1	1	1	2	2	3
1	1	1	1	2	2	3
1	1	2	1	2	2	3
2		2	1	2	2	3
2		2	3	3
2			3	3
3
3

<tbody>
</tbody>

Let me take each options above and explain
A - Want to insert a row between 1 and 2 and 2 and 3
B - Don't have to do anything since there is only one number
C - Want to insert a row between 1 and 2
D - Want to insert a row between 1 and 3
E - Want to insert a row between 2 and 3
F - Don't have to do anything since there is only one number
G - Don't have to do anything since there is only one number