Copy/Paste Active Cell to new worksheet problem

Are you always copying to B11 or to the next blank cell after B11?

All the cells being copied from Sheet1 will be random for the most part usually switching from (A2,B2,C2,D2,E2,F2,G2,H2) to (A3,B3,C3,D3,E3,F3,G3,H3) to (A4,B4,C4,D4,E4,F4,G4,H4) and so on. But I will be manually triggering the Active cell A2, A3, A4.

The cell on Sheet two will always be B11 every time.
So B11:J11, on Sheet2, will contain the section from Sheet1 of (A2,B2,C2,D2,E2,F2,G2,H2).

Thanks for the quick response!

Hello there,

Try the following

Please Login or Register  to view this content.

To insert the code

1.Press Alt+F8 on your keyboard
2.Clear the macro name box and type CopyCellRow in the blank box provided
3.Select the Create option
4.In between the Sub CopyCellRow() and End Sub copy and paste the above code.
5.Exit out of the Visual Basic Window
6.Select the cell whose row you want to copy and Press Alt+F8 again and this time select the CopyCellRow macro
7.Select Run

Let me know if this works for you!

When using this method, will I have to select the cells (A2,B2,C2,D2,E2,F2,G2,H2) or just click the single cell?
Because it seems that by using this method I will have to select the number of cells and then run the macro to transfer the information to Sheet2. If this is the case, would you know how to do it the original way presented? Because I have 10,000+ lines to go through. So the extra few minutes i save will go a long way.


Thanks,

ipmaham

With this you just select a single cell in the row you want to copy over.

Perfect, I'll give it a go here in a bit and report back. Thanks for all the help so far rvasquez! It's really appreciated.

No problem, since you have so man rows you may want to assign a short cut key to the macro so that you can just press Ctrl and whatever letter you specify to run it.

Thanks!

That's exactly what I was going to do. I already have a macro set up to save by a specific cell value in Sheet2 and it is assigned to a key.

Here is a thought. Is there a way to run this macro and the pause a second, and then run another macro?

Just add the name of the second macro below the last line of code before the End Sub of the code I gave you.

@ ipmaham

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

rvasquez ,

where exactly do I insert this code? do i place it in my original code on the bottom? Or just replace it all, I wouldn't think that though.

Originally Posted by rvasquez

Hello there,

Try the following

Please Login or Register  to view this content.

To insert the code

1.Press Alt+F8 on your keyboard
2.Clear the macro name box and type CopyCellRow in the blank box provided
3.Select the Create option
4.In between the Sub CopyCellRow() and End Sub copy and paste the above code.
5.Exit out of the Visual Basic Window
6.Select the cell whose row you want to copy and Press Alt+F8 again and this time select the CopyCellRow macro
7.Select Run

Let me know if this works for you!

[COLOR="Silver"]

If I read your first post correctly copy it over your original code. So that it look like:

Please Login or Register  to view this content.

Maybe try this:

Please Login or Register  to view this content.

Hello there, try this

Please Login or Register  to view this content.

Much appreciated, but I got it working with the help you provided on the 8th.

Thanks a lot!

LOL sorry about that, please mark this thread solved.

Thanks!