I need these two sets of VBA to paste on same line instead of one line below each other.The problem is they both look for an unused row, which is needed, but they should be on the same unused row. Thanks.
Please Login or Register to view this content.Here is the Macro that Calls both of these macros.Please Login or Register to view this content.
Please Login or Register to view this content.
hi gsot21, welcome to Excelforum, if I understood your request correctly
change this line:
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Attached is the workbook that I am referring too.
I have a order form people fill out that looks like this.
-invalid attachment-
I want to grab all of the data from this sheet(The headers of the tables below) and put it into rows, or in the case of the same person ordering multiple items, multiple rows. My Current VBA does this, but it doesnt line up correctly due to not having a single copy and paste function(I have multiple macros instead). I essentailly need something that will copy (A8:K22,B4,B5,J5) and place them all within a row. My Current VBA is bellow.
I have this VBA, below and it currently spits out data like this.
-invalid attachment-
And I want it to spit out like the Table below
-invalid attachment-
Please Login or Register to view this content.
Last edited by Paul; 08-15-2014 at 03:44 PM. Reason: Two threads merged (third deleted, which apparently had the attachments). Please re-attach files to this thread.
Hi gsot21
Try this Code for your Submit ButtonPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks