Hi, not sure if this would be possible but I currently have a user form which populates cells in worksheet 2, I would then want to copy rows sheet2 A1 to A18 and insert them into the next free row on sheet 1.
Hi, not sure if this would be possible but I currently have a user form which populates cells in worksheet 2, I would then want to copy rows sheet2 A1 to A18 and insert them into the next free row on sheet 1.
Last edited by zimbo109; 04-24-2010 at 12:42 PM.
Try this:
Please Login or Register to view this content.
If you want to put A1:A18 all onto one ROW on sheet1, then the data would need to be transposed:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks Jerry, will have a play with that, the first code is ideal. I'm not looking to transpose to one row.
Regards
Chris
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
The code at the moment pastes the copied rows into Sheet 1 is there a way I can INSERT them pushing all subsequent rows down?
Try this:
Please Login or Register to view this content.
This code does not find the next row now, and pastes the copied cells into A2?
Last edited by zimbo109; 04-24-2010 at 09:59 AM. Reason: spelling
Since I can't see your sheet and you're only half-asking your questions, I'm giving you basic enough answers that you will have to adjust them to work in your actual sheet.
I've shown you how to copy a row of data to the end of the data set.
I've shown you another way to insert.
Now you can provide a sample workbook and a much more complete question, or you apply/adjust what you've been given. Yes?
Hi Jerry, I'm just looking to insert the copied data to the end of the data set. The first code you kindly gave works great however this solely pastes and I would like to Insert, I have tried for hours to change your first code to insert but my limited knowledge in VBA is not working!
Merging the two suggestions into one:
Please Login or Register to view this content.
Perfect! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks