Hello,

Hoping someone can help with a formula or macro to copy data in rows to sheet2 based on the value in the row (column F). Column F does not need to come over to sheet 2 but the other column headings should.  Using the example below, row 2 would duplicate 17 times and row 3, 106 times.

I am using Excel365

Thanks in advance!

Ryan

​Hello, Hoping someone can help with a formula or macro to copy data in rows to sheet2 based on the value in the row (column F). Column F does not need to come over to sheet 2 but the other column headings should.  Using the example below, row 2 would duplicate 17 times and row 3, 106 times.I am using Excel365 Thanks in advance!Ryan  Read More

​