Copy paste based on row count of different column

[Edgarvelez]

Hi all,
I have to copy and paste D2 in D2 based on row count starting in C2.
Row count in C2 can be 1 or many (Dynamic). Thanks in advance.

 

[felixstraube]

I do not quite understand what you need. Could you explain in more detail and maybe provide some examples and expected results?

 

[Edgarvelez]

ok,
Cell A3 is always typed in nothing I can do about that.
Column C always starting on C2 has 3 rows filled so I need A3 duplicated total 3 times.
Keep in mind that Starting in C2 i might have 1 row filled in or many, so the range in dynamic

 

[Edgarvelez]

This is a Good result, basically just duplicating A times the row count of column C

 

[felixstraube]

How about this?:

Libro1
	A	B	C
1	Document_Type	BL_NUMBER	BL_DATEYYYYMMDD
2	BILL OF LADING	mN12nB3456	45264
3	BILL OF LADING	mN12nB3456	45264
4	BILL OF LADING	mN12nB3456	45265
5
6
7
8
Hoja1

Cell Formulas
Range	Formula
A3:A8	A3	=IF(C3<>"",$A$2,"")

 

[Edgarvelez]

Need it as code please it will be a part of another code

 

[Edgarvelez]

Need it as code please it will be a part of another code

Any help?