I'm having problems figuring how to correctly modify existing code to transfer data over from sheet (armele) to the 1st and 2nd page on sheet (Purchase Order Form) once the first sheet is full. The program worked fine until I added the second overflow sheet, now nothing works. Please help if you can!
Last edited by ElmerFud; 01-14-2016 at 02:09 PM.
Help meeeeeeeeeeeeeeeeeeeeeeeeeee!
Hi Elmer...don't give up the Ghost...
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.
Hi Elmer,
Peruse this code as a way to find the next available row in your purchase order form.
I'll let you figure out how to incorporate it into your existing code.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Hi Elmer
Try this Code to transfer data to the PO Worksheet.
Please Login or Register to view this content.
Thanks jaslake, That works pretty good.
Is there anyway you can fix it to delete the check marks on sheet armele after the items transfer over to Purchase Order Form.
Also, the user needs to manually type in as well on the Purchase Order Form if an item is not available on sheet armele. So it needs to know to insert to the next available row etc. etc. until full.
There needs to be no qty's brought over from the armele sheet the user will fill that in. So the identifier needs to be (Item Description) for the code to fill to the next row.
One last thing once the check marks are erased on sheet armele it needs to know not to start at the top again or overwrite what's already there.
Thanks Skywriter,Originally Posted by skywriter
Hi Elmer,
Peruse this code as a way to find the next available row in your purchase order form.
I'll let you figure out how to incorporate it into your existing code.
Please Login or Register to view this content.
Not sure how to go about that or where to put your code. Can you implement your code into the code I've given. I would greatly appreciate it. Thanks!
Hi Elmer
I'll look at it tomorrow.
Hi Elmer
I believe these issues are addressed...
Is there anyway you can fix it to delete the check marks on sheet armele after the items transfer over to Purchase Order Form.
Also, the user needs to manually type in as well on the Purchase Order Form if an item is not available on sheet armele. So it needs to know to insert to the next available row etc. etc. until full.
There needs to be no qty's brought over from the armele sheet the user will fill that in. So the identifier needs to be (Item Description) for the code to fill to the next row.
One last thing once the check marks are erased on sheet armele it needs to know not to start at the top again or overwrite what's already there.Please Login or Register to view this content.
Most excellent, that's why your the man! (jaslake) I can't tell you how much I appreciate this. Thanks again!!!
You're welcome...glad I could help.
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