Hi,
I have been not having any luck searching for a formula to copy a complete row to another sheet in the same worksheet, using a checkbox.
From the Parts sheet, if I click the checkbox for that item, I'd like it to copy to the Orders sheet
Also needs to remove the data from the 2nd sheet (in this case, the Orders sheet) if the checkbox is unticked.
Thanks in advance for your assistance.
Hi GlobalTr
Welcome to the Forum!!!
This Code in Sheet Parts Module does not use Check Boxes but see if it does as you require. Right Click on any Cell in Column D of Sheets Parts to add or remove the Part from Sheet Orders.
Please Login or Register to view this content.
Last edited by jaslake; 08-25-2017 at 07:23 PM.
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 John
Thank you so much. You nailed it 1st time.
Awesome work legend.
Anthony
newby question, how do I mark the thread as solved?
Hi Anthony
You're welcome...glad I could help. Thanks for the Rep.
To mark Thread as SOLVED select Thread Tools from the menu link above and mark the thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks