Auto crate rows based on a cell with input value

[Bee67]

Hi
Trying to get my spreadsheet to create a number of rows with some prepopulated values in certain columns based on an input value of number of rows to create.
Example:
Cell B2 contains an input value between 1-9999.
When a value is entered the equivalent number of rows should be added, starting at row 4. Some of the column values in the row should be prepopulated with values.
It also needs to be dynamic so, if the value in B2 is changed, the number of rows pre populated is also changed.
Can anyone help?
TIA

 

[awoohaw]

Where are the "Prepopulated Values" that you want added to the new rows? How do you want the rows labeled?
So, if B2 has a value of 10.. you want to rows created.. some of them populated with data from somewhere else... what/where is that data?
Does the data have any rules that need to be followed regarding how it is put into the new column of rows?

Please use the xl2bb add in and post an example of what you'd like? and also some sample of the other column of data that is supposed to be mapped onto the new column.

 

[Bee67]

Hi awoohaw

Thanks for replying.

Yes you’re right. If b2 has a value of 10 then in need 10 lines generated.

The rows would be labelled using a ref number starting at 0001 and with a max of 9999.

The data can be held on a separate sheet in the workbook and is very simple. No rules - always the same value in each column. So for each row column A would have an incrementing ref no. and each column the same value so col B w oh ld always default to ‘red’, col E default to ‘open’.

I am trying to load the add in but it isn’t working right now. As soon as I get it to work I’ll add an example sheet.

Thanks.

 

[awoohaw]

Okay, in the meantime, I'll try to create a small working file. Hopefully, I'll match your words to a spreadsheet.

 

[awoohaw]

Okay, here is what I think you asked for: Instead of adding sheets, i put the RED and OPEN values off to the side.

Mr Excel Questions2.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ROWS to CREATE:	10	(1-9999)
2
3	A	B			E
4	0001	RED			OPEN
5	0002	RED			OPEN
6	0003	RED			OPEN		Other Sheet:		B Column:	RED
7	0004	RED			OPEN		Other Sheet:		E Column:	OPEN
8	0005	RED			OPEN
9	0006	RED			OPEN
10	0007	RED			OPEN
11	0008	RED			OPEN
12	0009	RED			OPEN
13	0010	RED			OPEN
14
Sheet22

Cell Formulas
Range	Formula
A4:A13	A4	=TEXT(SEQUENCE(B1,1,1,1),"0000")
B4:B13	B4	=INDEX($J$6,(ROW(A4#)^0),0)
E4:E13	E4	=INDEX($J$7,(ROW(A4#)^0),0)
Dynamic array formulas.

 

[Bee67]

This is great and does what I need.
Thank you very much!

 

[awoohaw]

Great, best wishes! Have a great day!