section of cells that grow when a button is pressed

[Alan-1951]

Greetings All

I have been trying to find a way to make this happen
When the + is pressed everything inside the red is duplicated below ( with B 10 as the top corner ( C 6 / H6 / m6 contain drop down lists )
This would need to happen every time the + is pressed
It would be nice if everything in the red box could be deleted but that is properly a big ask

 

[HighAndWilder]

Greetings All

I have been trying to find a way to make this happen
When the + is pressed everything inside the red is duplicated below ( with B 10 as the top corner ( C 6 / H6 / m6 contain drop down lists )
This would need to happen every time the + is pressed
It would be nice if everything in the red box could be deleted but that is properly a big ask

View attachment 123787

What version of excel are you using? Could you please update your profile with the version.

Are the drop down lists is C 6 / H6 / m6 actually validation lists and if so where do they get their data from?

Can you please post a mini-sheet using XL2BB so that we can see what data is where and where the merged cells are?

 

[Alan-1951]

Microsoft® Excel® for Microsoft 365 MSO (Version 2502 Build 16.0.18526.20168) 64-bit
The data for the dropdown list is located on a second page called ( Dropdown Items )

Email Filters ( Blank ).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2			FILTER NAME
3
4
5			RULES
6			Select From Dropdown					Select From Dropdown					Select		-	+
7
8
9
10
11
12			ACTIONS
13															-	+
14
15			/INBOX
16
17
18
Work Sheet

Cells with Data Validation
Cell	Allow	Criteria
C6:F6	List	='Dropdown Items'!$A$6:$A$20
H6:K6	List	='Dropdown Items'!$A$22:$A$35
M6	List	='Dropdown Items'!$A$38:$A$40
C13:F13	List	='Dropdown Items'!$A$44:$A$50

Email Filters ( Blank ).xlsx
	A
4
5	RULES
6	Select From Dropdown
7	From
8	Subject
9	To
10	Any Recipient
11	Reply
12	Body
13	Any Header
14	Has Not Been Previusly Delivered
15	Is Error Message
16	List
17	ID
18	Span Status
19	Spam Bar
20	Span Score
21
22	Select From Dropdown
23	contains
24	matches regex
25	does not contain
26	equals
27	begins with
28	ends with
29	does not begin
30	does not end with
31	does not match
32	is above ( numbers only )
33	is not above ( numbers only )
34	is below ( numbers only )
35	is not below ( numbers only )
36
37
38	Select
39	AND
40	OR
41
42
43	ACTIONS
44
45	Disgard Message
46	Redirect to Email
47	Fail With Message
48	Stop Processing Rules
49	Deliver to Folder
50	Pipe to a Program
51
Dropdown Items

 

[Alan-1951]

How i would envisage it working that when the + box is pushed in the red box ( RULES ) a second block is added and the green box ( ACTIONS ) moves down and so on.
The same with the green box ( ACTIONS ) when the + is pressed a second and so on is created

Email Filters ( Blank ).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2			FILTER NAME
3
4
5			RULES
6			Select From Dropdown					Select From Dropdown					AND		-	+
7
8
9
10
11			Select From Dropdown					Select From Dropdown					AND		-	+
12
13
14
15
16			ACTIONS
17															-	+
18
19			/INBOX
20
21
Work Sheet

Cells with Data Validation
Cell	Allow	Criteria
C6:F6	List	='Dropdown Items'!$A$6:$A$20
C11:F11	List	='Dropdown Items'!$A$6:$A$20
H6:K6	List	='Dropdown Items'!$A$22:$A$35
H11:K11	List	='Dropdown Items'!$A$22:$A$35
M6	List	='Dropdown Items'!$A$38:$A$40
M11	List	='Dropdown Items'!$A$38:$A$40
C17:F17	List	='Dropdown Items'!$A$44:$A$50

 

[HighAndWilder]

How i would envisage it working that when the + box is pushed in the red box ( RULES ) a second block is added and the green box ( ACTIONS ) moves down and so on.
The same with the green box ( ACTIONS ) when the + is pressed a second and so on is created

Email Filters ( Blank ).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2			FILTER NAME
3
4
5			RULES
6			Select From Dropdown					Select From Dropdown					AND		-	+
7
8
9
10
11			Select From Dropdown					Select From Dropdown					AND		-	+
12
13
14
15
16			ACTIONS
17															-	+
18
19			/INBOX
20
21
Work Sheet

Cells with Data Validation
Cell	Allow	Criteria
C6:F6	List	='Dropdown Items'!$A$6:$A$20
C11:F11	List	='Dropdown Items'!$A$6:$A$20
H6:K6	List	='Dropdown Items'!$A$22:$A$35
H11:K11	List	='Dropdown Items'!$A$22:$A$35
M6	List	='Dropdown Items'!$A$38:$A$40
M11	List	='Dropdown Items'!$A$38:$A$40
C17:F17	List	='Dropdown Items'!$A$44:$A$50

Give this a go on a copy of your 'Work Sheet' worksheet in a new workbook.

This code goes in the 'Work Sheet' sheet code module.

It would be handy if you could post a mini-sheet using XL2BB containing a number of rules and actions.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rngWhat As Range
Dim strWhat As String
Dim intRow As Integer

  If Target.CountLarge > 1 Then
    Exit Sub
  End If
        
  If Target.Value = "+" Then
                
    Target.Offset(4, 0).EntireRow.Resize(5).Insert
    
    Target.Offset(0, -14).Resize(4, 16).Copy Destination:=Target.Offset(5, -14)
        
  End If
  
  If Target.Value = "-" Then
  
    Target.Offset(-1, 0).Select
  
    If Len("RULES,ACTIONS") > Len(Replace("RULES,ACTIONS", Target.Offset(-1, -12).Value, "")) Then
      MsgBox "Invalid action.", vbOKOnly, "Warning"
      Exit Sub
    End If
      
    Target.Resize(5, 1).EntireRow.Delete

  End If
  
End Sub

 

[Alan-1951]

Greetings

HighAndWilder​

The RULES and ACTIONS are listed earlier on in this thread, is that what you are looking for.

 

[Alan-1951]

Greetings All

High And Wilder : provided a most excellent solution for this question.
Went well beyond the brief in providing the solution.
I had been trying to achieve a solution for days but only came close, it never worked as expected.
Many thanks for your assistance, a real credit to Mr Excel Community