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
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
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
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
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
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
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:
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