Insert n number of rows based on n number in a cell

[Tashat]

Hi all

I have two sheets within a workbook. One shown below on A1:I9 is a record of activities. From each activity, there will be a number of actions and on a different sheet I want to "insert" the correct number of rows dependent on the number of actions entered in column I. I also want it to auto-complete some of the information. I.e. as shown in A13:D:27. I would have other columns on the second sheet that the user would manually complete in order to track their actions. Is there a way of doing this? I assume it would require a macro? I'm also wondering what would happen if for example the number of actions was changed in column I at a later date, either increased or reduced. Many thanks in advance.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Unique Record Number	Date of Activity	Activity	Objective of Activity	Organisation Name	Organisation Type	Response to the Meeting	Did the Group Offer Supprt?	Number of Actions
2	ACT001	10/01/2021	Phone Call		ABC	1	Positive	Yes	3
3	ACT002	10/01/2021	Video Call		DEF	5	Negative	No	1
4	ACT003	11/01/2021	Meeting		GHI	2	Neutral	No	0
5	ACT004	15/01/2021	Meeting		JKL	7	Neutral	Yes	5
6	ACT005	16/01/2021	Phone Call		MNO	3	Positive	Yes	2
7	ACT006	16/01/2021	Phone Call		PQR	1	Positive	Yes	1
8	ACT007	19/01/2021	Video Call		STU	2	Positive	Yes	0
9	ACT008	19/01/2021	Video Call		VWX	2	Negative	No	2
10
11	This would be on a different sheet within the same workbook
12
13	Unique Record Number	Date of Activity	Organisation Name	Organisation Type
14	ACT001	10/01/2021	ABC	1
15	ACT001	10/01/2021	ABC	1
16	ACT001	10/01/2021	ABC	1
17	ACT002	10/01/2021	DEF	5
18	ACT004	15/01/2021	JKL	7
19	ACT004	15/01/2021	JKL	7
20	ACT004	15/01/2021	JKL	7
21	ACT004	15/01/2021	JKL	7
22	ACT004	15/01/2021	JKL	7
23	ACT005	16/01/2021	MNO	3
24	ACT005	16/01/2021	MNO	3
25	ACT006	16/01/2021	PQR	1
26	ACT008	19/01/2021	VWX	2
27	ACT008	19/01/2021	VWX	2
28
Sheet1

 

[DanteAmor]

I'm also wondering what would happen if for example the number of actions was changed in column I at a later date, either increased

In that case, using your example from ACT001, if you have 3 and you increase it to 4, then a new record would be created on sheet2.

or reduced

In this case, and following your example from ACT001, if you have 3 and reduce it to 2, then 2 records should be deleted from sheet2, but which 2 records should be deleted, the first 2, the last 2. In this part you must explain what would be the pattern to follow to delete the records.

 

[Tashat]

In that case, using your example from ACT001, if you have 3 and you increase it to 4, then a new record would be created on sheet2.


In this case, and following your example from ACT001, if you have 3 and reduce it to 2, then 2 records should be deleted from sheet2, but which 2 records should be deleted, the first 2, the last 2. In this part you must explain what would be the pattern to follow to delete the records.

Hi DanteAmor - thank you for replying. I think I might need to rethink the whole things, because it's going to be too complicated to manage, because if the number is reduced, there will be information in the concurrent columns which remains. thank you for your help though.