When one of our newer employees got his new PC, he was having problems opening one of his Access files. When I tried to help with the security level on the file, I used the wrong "Security" under the Tools pulldown and really screwed things up for him.
Instead of going to Tools/Macro/Security...
Awhile ago there was a thread (thread68-720840) going whereas xlbo wrote the following formula:
=SUMPRODUCT((Left($B$1:$B$4,3)="SER")*($C$1:$C$4="Policy"))
I'm trying to modify this formula to work for a project that will be done on a daily basis.
Here's the scenario:
Column A will consist...
Someone else asked this question already but it was posted in 2002 and no one had an answer so now it's MY turn. :)
I have an associate who uses Outlook 2000 and is using Word to edit his e-mail. For some reason, his zoom in Outlook keeps defaulting to 75% which looks very tiny. I've changed...
First, our company uses Office 2000.
I want to create a form that managers have to fill out that has approximately 75 questions. Depending on what employee level the associate is (answer entered in cell B9) determines which questions the manager wants to show up in the rows below in which they...
Using Windows 2000, Office 2000
Before we go any further, picture this:
You open Excel...it shows Book1...you close the file, not the program...you now have a big gray empty space in the middle of your monitor.
Ok, hold that thought now. :)
An associate at the company I work for keeps...
I have a file in Excel that has 30 columns and over 3,000 rows of text and I need to sort by more than 3 columns as is usually the case because I'm looking for duplicates and it'll take more than 3 columns to decide which are duplicates.
Is there a way to sort by Column A, then Column B, then...
I'm having a problem adding and/or deleting rows and I "think" I know the answer but I'd like some other feedback before I decide to just do away with Interdev and start learning Dreamweaver which my company has been kind enough to purchase for a few programmers. Mind, I'm not an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.