Biggest Challenge For Excel Experts

[Satya Ranjan]

Each line is to be repeated by the nos of qty and in each line qty will be 1.


Is there any way we can do this in excel?

Thanks

 

[pgujju143]

Re: If you are not a super expert in excel then this question is not for you.

Hi Mr Satya,

Try below code this code useful to you.

as per your above explanation your qty column qty reflect 4 and a,b,c are copy and pasted 4 time. that means you need to how much qty in qty column you need to paste this job code that time

Sorry my bad english

Sub Multiple_Qty()
Dim lRow As Long
Dim RepeatFactor As Variant


lRow = 1
Do While (Cells(lRow, "A") <> "")

RepeatFactor = Cells(lRow, "D")
If ((RepeatFactor > 1) And IsNumeric(RepeatFactor)) Then

Range(Cells(lRow, "A"), Cells(lRow, "D")).Copy
Range(Cells(lRow + 1, "A"), Cells(lRow + RepeatFactor - 1, "D")).Select
Selection.Insert Shift:=xlDown

lRow = lRow + RepeatFactor - 1
End If

lRow = lRow + 1
Loop
End Sub

pls try same correction done by above code
as per above coding you must on to changes as per your QTY column.
D" is Repeat Factor

 

[Michael M]

Re: If you are not a super expert in excel then this question is not for you.

This another different scenario to the previous ones.
We keep offering a solution to your issue and you have been responding with changes to the requirements.
I suggest you have a rethink on what you actually NEED.....then upload a before and after sample of data to a hosting site, so that someone may download and modify to suit......but it won't be me... .....