Copy Row macro modification needed

[darbar76528]

Hey everyone. I was wondering if someone could help me with this problem. I have a macro that copies rows and it does a great job, however, I need to modify it as follows: I need the macro to copy to a different column(other than A). Ideally, I would like the copied cells(Column A:D) to be copied over to Column I:L starting at row 31 and then advancing downward(this is where I am having problems). I have made several attempts to do this, but have been unsuccessful. Thanks in advance!

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[bakerman2]

How about this ?

Please Login or Register  to view this content.

[darbar76528]

If I could bother you once more. BTW:Your above code worked beautifully! I have another macro that interacts with the copy macro listed above and I was wondering if you could tweak it as well. Here is a look at the code:

Please Login or Register  to view this content.

As written, the checkboxes are placed to the far right side of the row that is being copied. In my sheet the checkboxes are placed in column C. I want to also place the checkboxes in Column F and Column I starting at row 31. Can this be done? Thanks!

Also, I notice that as the rows are copied over to Column I, they stay on the same row that they came from instead of starting off at I31 and advancing down to I32,I33,etc. Can that problem be solved as well?

[bakerman2]

This should solve the row issue and also start in correct Column.

Please Login or Register  to view this content.

But in that case your Checkboxes will be over Column I data. Is that correct ?

[darbar76528]

To better convey what I am trying to accomplish, I have attached a file to assist. The first random checkbox, once selected, and the button "copy selected rows" is pressed, should copy the two cells located to the immediate left to L32:M32. The next checkbox selected would populate in L33:M33 and so forth.

In other words, if I select the checkbox in F37 and then hit the "copy selected rows" button, it should copy cells D37 and E37 to L32 and L33. If I then or also selected checkbox I53 and hit the "copy selected rows" button, it should place cells G53 and H53 into cells L33:M33 and so forth...

If I select 10 different options, the 10 options should populate, one after the other in L32:M41

Hope this helps.

[bakerman2]

No need for extra button. When a checkbox is ticked to True then values are copied to other range.

[darbar76528]

Your solution to this is superb! I will study the coding to figure out how this actually works. I want to thank you so much for your help with this problem.
Sincerely

[bakerman2]

You're welcome and thanks for rep+.