Macro to Copy Rows based on User Input

**CharterJP** · 07-19-2012, 04:31 PM

Hi Excel Experts,

Here is my problem and I've included a test workbook as well. I have a list of rows each with a unique id. What I need is to beable to pick any of the id's and then specify the number of times I want that id copied below the cell (each copy creating a unique sub id) forexample. If I am copying id 1 two times. the sub ids could be 1.1 and 1.2. Further, each of the rows, the one copied from and the copies of that row need to be populated with data sets. See Column H, I and J from row 2 through 7. They have blank columns in the table that will match.

Can you help?mocktest.xlsx

**CharterJP** · 07-19-2012, 05:43 PM

Do my example require further explaining? I would greatly appreciate some help on a solution.

**CharterJP** · 07-19-2012, 06:14 PM

I do not mean to harp but I could really use some help on this.

**rylo** · 07-19-2012, 07:05 PM

Hi

Here's a start.

Please Login or Register  to view this content.

rylo

**CharterJP** · 07-20-2012, 10:09 AM

Rylo,

You are awesome! Thank you for this piece. It works beautifully. Would you happen to have thoughts on how to populate the newly created and copied cell with the data in H2 through J7?

**rylo** · 07-20-2012, 04:43 PM

Hi

I'm working on the principle that the number of extra rows, plus the original will match the number of rows of data to be filled in columns H:J.

Please Login or Register  to view this content.

rylo

**CharterJP** · 07-24-2012, 09:52 AM

This macro works very well. The data I used in H:J is only a very small set of the actual. I will have to adjust the macro to fit the range needed. Otherwise, I can't thank you enough!

**CharterJP** · 07-24-2012, 05:22 PM

Rylo, I am having an issue with this code. I am using in my work book as it is writen and when I get past the first few IDs it starts copying all the way down and losing ID order. Could you help?

**rylo** · 07-24-2012, 06:13 PM

Hi

Put up an example file that replicates the problem, and include the code.

rylo

Macro to Copy Rows based on User Input

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Copy Rows based on User Input

Re: Copy Row Issue

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Re: Macro to Copy Rows based on User Input

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions