Macro to duplicate rows based on cell value

**ctguards1987** · 07-22-2022, 01:27 PM

Hello All,

Hoping someone can help to see if a macro is feasible for this task. Per attachment, The tab called "HC Report" is the input tab where i am hoping based on column A(Quantity), if a Marco can be run to copy the records in the "Result" tab based on the quantity specified. So if quantity = 2 then the results tab will have 2 of the same records.

Can someone help me develop this Marco if possible ? I searched in YouTube and goggle but did not find anything that would assit completing this task.

**oeldere** · 07-22-2022, 01:37 PM

With text to column.

After that saved as an excel file.

See the attached file.

**ctguards1987** · 07-26-2022, 12:26 PM

Sorry, i don't see any Marco assigned. I attached a zip file which has the excel example where i need the Macro to duplicate the rows based on quantity inputted in the first tab for the cell.

Just need a Marco to copy the records in the "Result" tab based on the quantity specified. So if quantity = 2 then the results tab will have 2 of the same records.