Hi all I would like to pick out some items in a list and paste them on another sheet see example spread sheet
Pick from list.xlsm
Hi all I would like to pick out some items in a list and paste them on another sheet see example spread sheet
Pick from list.xlsm
Last edited by pfereday; 06-09-2012 at 09:27 AM. Reason: Sorry didn't read the rules
Be sure to EDIT your thread title as per forum rules (read in menu link above).
1) Move the TOTAL line up above the details, I moved it to D6:E6 and expanded the SUM to 100 rows.
2) Put this in the Work Details sheet module:
The doubleclick code with both add and remove the tick mark.Please Login or Register to view this content.
3) Put this in the a regular code module (Insert>Module) then connect it to your DONE button:
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!)
Does that work for you?
Absolutly amazing thank you
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks