$$Excel-Macros$$ IF two criteria then count occurrences of "TRUE"

2011-01-13 Thread mikeb
actually have many different types of tests to do, I am only showing one; if we can solve this I will just extrapolate for the other tests. Any help will be greatly appreciated. Thank you, MikeB -- -- Some important

$$Excel-Macros$$ UserForm

2010-09-22 Thread mikeb
columns in sheet test2, that we are placing the userform information. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA

2010-07-02 Thread mikeb
HI Larry! Thank you for your advice, I will keep this in mind going forward. Have you specificaly converted any QuickBasic programs to VBA, if so what do you think the work effort is on a scale 1 - 10 (10 being most effort). Thank you again for your help and advice. The Best MikeB On Jul 1, 7

$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA

2010-07-01 Thread mikeb
Thank you for your help and direction Tomaz! The Best MikeB On Jul 1, 3:51 am, Tomaz wrote: > I use to program in QBASIC and QuickBasic some 15 years ago. > There is a book called " The Revolutionary Guide to QBASIC" from WROX. > There is lot you can use to convert to VB or

$$Excel-Macros$$ Keywords from QuickBasic to VBA

2010-06-30 Thread mikeb
you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3

Re: $$Excel-Macros$$ IF AND formulas

2010-05-12 Thread mikeb
time. I hope I have explained it clearly enough. I cannot send the file because it is propriety information. Thank you, MikeB On May 12, 5:17 am, Dave Bonallack wrote: > Hi, > > A sample file would be good, but to simplify your formula, use a a name for > 'Test Plan'!$I$13:$I$10

$$Excel-Macros$$ IF AND formulas

2010-05-11 Thread mikeb
I would appreciate any help on the following formula which I cannot get to work: =IF(AND('TEST PLAN'!$U$14:$U$10134="11",(IF(SUM(IF('Test Plan'!$I$13:$I $10134="NB",1,0)))>0,SUM(IF('Test Plan'!$I$13:$I$10134="NB",1,0)), 0)+IF(SUM(IF('Test Plan'!$I$13:$I$10134="QU",1,0))>0,SUM(IF('Test Plan'!$I$13:

$$Excel-Macros$$ Find, Copy, Paste to different worksheet

2009-09-04 Thread mikeb
HI All! I would appreciate some direction for a VBA macro to do the following: First I have a workbook with a summary sheet and approximately 50 individual worksheets with a specific file number on each tab. I want to be able to search each worksheet (one at a time) and Find a specific name in c