Hi Everybody, I need to copy a specific row on 1 worksheet and paste to another. It must find last used row +1 (so it skips a row when pasting)
This is what I have now and it does not work.....
I need it to copy Range "A6:V6" on first worksheet and paste, finding the last used row then skip a row, on 2nd worksheet.
Please Login or Register to view this content.
Last used row will be in column B
Last edited by Pat1009; 07-11-2015 at 11:17 AM.
something like this
Please Login or Register to view this content.
Maybe this....
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
It does now copy/paste, but it starts pasting in Column C not B and it does not skip a row before pasting.
I need it to find last used row, then leave a blank row, then paste.
Last edited by Pat1009; 07-11-2015 at 12:26 PM.
Please Login or Register to view this content.
that worked for leaving the blank row but it still pastes, starting in column C instead of B.
Last edited by Pat1009; 07-11-2015 at 12:13 PM.
It should paste in Column B...check if maybe your first cell i.e. A6 maybe blank....
If not, then kindly upload your workbook....
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Hi Pat1009,
Could you please attach an example of a file, where it still pastes, starting in column C instead of B
ok, I will
For some reason it will not let me post it using HTML Maker
Last edited by Pat1009; 07-11-2015 at 12:29 PM.
For some reason it will not let me post it. I don't know if this matters, but on sheet 2 column A is blank except for A1
Last edited by Pat1009; 07-11-2015 at 12:30 PM.
For uploading the workbook, you need to click on "Go Advanced" button at the foot of the typing area and then clicking on the "Paper Clip" icon from the tools above...
Ok, it is attached, Run Module # 4 in the VBA Editor, then look at the Sheet names Exceeds, at the bottom
I told you you would be having A6 as blank...
So just change the Offset code to-
Offset(2, -1)
Beautiful, this works, thank you Sourabhg98 and to you too Nilem
Glad to know that worked!!
If your query is solved, kindly mark this thread as solved from the "Thread Tools" at the top of this page..
Sour, do you think you can help me with another problem I am having with this code?
Instead of telling it to Paste on Pasterow =3, I need it to find the last used row and paste right below it. You can find it in module #2 of my posted workbookPlease Login or Register to view this content.
Not sure what you need...
But try this-
Change this---
If ws2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).row > pasteRow Then pasteRow = ws2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).row
to
If ws2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).row > pasteRow Then pasteRow = ws2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).row + 1
or
If ws2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).row > pasteRow Then pasteRow = ws2.Cells(Rows.Count, 2).End(xlUp).Offset(2, 0).row
that did not work, it only created an empty row between each row of data.
This part is what I am talking about.....
This is a better example of what I need changed
If ws1.Cells(i, 4) = "A" And ws1.Cells(i, 12) > 72 And ws1.Cells(i, 12) < 240 And ws1.Cells(i, 14) = "Standard" Then
pasteRow = 23
I believe I am telling it to Paste, starting on Row 23, I want to tell it to paste after the last row used, because the date that it finds will change monthly
So instead of 23 you want it to say the last row??
Then use this
pasteRow = ws2.Cells(Rows.Count, 2).End(xlUp).Offset(2, 0).row
This would give in this case pasterow = 42
This also did not do it. But, if you look at the worksheet names "Tony Exceeds SLO Comments" (right next to the "Exceeds" worksheet).
What I am trying to do is make the "Exceeds" worksheet look exactly like the other worksheet, but have VBA do it in Module #2. Feel free to create a new module, if you want to help me.
The data is coming from the "All Restoration Cases" worksheet. (this is the raw data).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks