Return duplicate row values in new table based on single cell value

Good morning everyone,

I am new to the forum and am having trouble figuring out a resolution to my problem.

I would like to enter a numerical value in a column and have it copy and paste that row data into a new table. IE. I would have a row that contains 6 columns with values. In the 7th column I would like to type in a numerical value say (10) and have it return that entire row into a new table 10 times. I am at a loss and have searched high and low with no results. Please let me know if there is a vb loop or other option that I can create to do so.

Thank you all so much for your help and I look forward to further communication.

hi VDubz, welcome to the Excel forum, it would be helpful if you upload sample workbook showing original data layout and result you need to obtain

please check example, press Start, hope it helps

Thanks for the prompt response watersev. I am not sure your sample is exactly what I am looking for. Attached is a sample of what I am trying to accomplish. On my source tab is sample data that I would like to be copied and pasted into my target tab. I would like it to paste the columns associated with that row into my target table. The same record will be created in the target table based on column E of the source table.

So based on my sample, I would like row 2 of source table to be copied and pasted 4 times in my target table. The underlying rows will follow same suit based on value entered in column E.

Thanks again for the help!

option to make it, press Start

That is awesome! However, I am a newb and would like to understand the VB code. Is is possible to give me a brief narration?


Thank you so much!

the code was slightly changed to process correctly mistaken values like letters instead of numbers.

Please Login or Register  to view this content.

THanks for the explanation!