Conditional Hide... Please Help!
I am trying to make a conditional hide with the following statement:
Is there a way to add another condition to the same row? I need excel to
hide "#VALUE!" as well. I tried =IF($I14<>"CONST","Hide","Show"), but this
will not pick up the "#VALUE!" cells. Is there a way to add to the statement
so I can include both?
Any help is greatly appreciated.
P...Please help me!
Like an idiot, I followed my husband's advice and signed into MSN Messenger
through ebuddy.com. I didn't like it, and now I can't figure out how to get
rid of it. It shows the link on Messenger while I'm signed out. Such a pest!
Can you help me? I can't find any answers through Googling it.
...Faulting application Dynamics.exe, ** Please Help**
Faulting application Dynamics.exe, version 188.8.131.52, time stamp 0x479e6592,
faulting module ntdll.dll, version 6.0.6002.18005, time stamp 0x49e03821,
exception code 0xc0000005, fault offset 0x00066796, process id 0x45d4,
application start time 0x01cb37e5aa4a6dc8.
This issue is giving me greif. I have done many hours of research without a
win. Please help is you have a solution.
We are having the same problem in a XenApp 6 environment hosting GP. It
appears to be related to certain printer drives, but not 100% sure. Is
anyone else having similiar problems?
"YKAdminis...Newbie help please
Can any one tell me where my inbox (and subfolder) messages are stored on my
PC? I would like to back them up in a completely separate location.
I'm using xp home if this helps.
not too techy please and TIA
This rubbish comes from firstname.lastname@example.org ,
the nicest taxi driver since
Robert De Niro in the film.......er......no, wait a minute..
I know! BERNARD CRIBBENS in "Casino Royale"
Yep! that's better!
Now with a super new webbysitey thingy at
(remove nibblemynuts to reply)
Hi, in Outlook 2002, select menu Too...Alias Advice Please
I have 2 clients that drive me nuts! We all have them.
Here is what they want to do. Mary Kay and Suzanne are nurses in our
organization. They want to send out emails from the address
NurseServices@mydomain.com. They want to both receive any replies to their
own inbox. Their accounts are MaryKay@mydomain.com and
Suzanne@mydomain.com. I know you can do it with different accounts POP3 and
exchange server however this account would be on the same exchange server.
Thanks in advance,
perhabs this little tool is the solution: http://www.lucatec.de/mask
This i...Help please #4
I want to write a formula that would link text into another worksheet i
there was text on a certain cell, if blank it would not link to th
other worksheet. Example: if column A contains a number and Column
contains a description, the number and decription would print on th
"linked to" worksheet cells and print. If there is no number in colum
A, nothing would appear in the cells and nothing would print
Posted from - http://www.officehelp.i
J2: =IF(Sheet1!B1<>"",Sheet1!B1,...read the message please
Your previous transaction-level posting session has not finished processing.
please allow time for it to finishg. if you believe it has faild, log out of
and log back in to recover transactions.
i do it but nothing,
i run check link and nothing
i restart the server but nothing
last i delete the transacctions in dynamics but nothing.
who want to help me.
...Test Mail...Please Ignore #13
Testing NNTP Client,
Please ignore message
I have a sheet that recaps hours of service. But the rules have changed and
I cant figure how to do this now
B10 thru 41 = day of month
1 - 31
C10 thru 41 = hours worked that day
D10 thru 41 = total hours on duty in the last 7 days
E10 thru 41 = available hours
F10 thru 41 = total on duty in last 8 days
what I need is a way that when there are 34 or more hours off duty to reset
the available hours back to 70. and restart the count from 7...word to excel mail merge help please....
Here is the question/problem explained:
I have created a Mail Merge document in Word. The information that is being
merged into the document is coming from an Excel file. All of the mail
merge fields have been set up in the main document (and are labeled the
same.) I have a portion of the document set up in a "bullet" list like
When I merge the info into the document it shows up like this:
2. b c
3. d e
4. f g
Do you know what I can do to fix this problem?
You would have to give some more information about the mailm...Can I resolve email address from incoming email to my customize en
I add new entity such as agency, agent. And most incoming email come from
agent, not contact which are our client.
is it possible to resolve incoming email to agent who are not in contact
list but in agent entity list ? Please advise.
...Why is this Load Event code not working? Please help.
I am trying to disable some controls on a form when it opens using this Load
event but it is not working. Is there something I am doing wrong. I even
tried using .Visible and that didn't work either. Can someone please tell me
what I am doing wrong. Thank you.
Private Sub Form_Load()
If Me.txtVendor.Value = Null Then
Me.txtVendor.Enabled = False
If Me.txtReviewer.Value = Null Then
Me.txtReviewer.Enabled = False
If Me.txtBeginDateRange.Value = Null Then
Me.txtBeginDateRange.Enabled = False
'Me.lblSDR.Enabled = False
I am fairly new to excel and have a problem that I have been trying to
solve on my own for days without any luck. Any help will be greatly
I would like to extract values from a column (column D) in a spreadsheet
where the text (column B) in a different column of the spreadsheet
matches a certain criteria in the numerous rows and have the results of
these values added up and the answer placed in a cell...
Thank you kindly in advance,
http://www.officearticles.com/excel/sumif_using_multiple_criteria_in_microsoft_excel...TWO QUESTIONS: Validation & Spacing...PLEASE HELP
Validation: I am in the cell that has the validation selection, but when I
select validation I cannot see where the person who created the sheet put the
validation choices, how can I find where he typed in his validation table of
Spacing: I want to have a cell where I can type three lines of text and have
a space between each line without it having to go into a new cell. So I want
the three lines of text and three blank lines in between in one cell.
Thanks for the help.
Q1- Each cell in the spreadsheet is independent;
With a given cell selected, go to Data, Validation..
If di...PLEASE HELP- How do I convert from Publisher to JPeg file?
I need to figure out how to convert the publisher file to Jpeg and also I
need to make it a 300 dpi resolution... Anyone know how to do this? Thanks!!!
You can thank Joanne Paules for finding the solution to this goal of yours.
SnagIt will do what you want. It is ~$40
It is a great program and I use it often.
"VibrateLovedotcom" <VibrateLovedotcom@discussions.microsoft.com> wrote in
>I need to fig...The name could not be resolved. The Microsoft Exchange address book was unable t
I have a SBS 2003 Server with Exchange 2003 setup. We
transferred over about 25 users and they are all able to
use Exchange with Outlook. I have entered the first new
user since the migration from Exchange 5.5 and I am
unable to connect an Outlook client to the new user from
a client computer. I can connect to another existing
user with the Outlook client. I used the new user wizard
to create this. I can go into Outlook WebMail and hook
up with that new user.
This is the error I get with the new user.
The name could not be resolved. The Microsoft Exchange
address book was u...Folders please help
We are trying to use Outlook for our business. We are
adding in all of our contacts in to the contacts folder.
In that folder we want to make seperate folders for each
businesses folder. Like Page 1., Page 2.. Do you
understand? If you need more explaining please let me
Gloria <email@example.com> wrote:
> We are trying to use Outlook for our business. We are
> adding in all of our contacts in to the contacts folder.
> In that folder we want to make seperate folders for each
> businesses folder. Like Page 1., Page 2.. Do you
> und...An answer please!
I have been using Office 2000 for many years. FrontPage is part of the suite
and I have used it successfully for to create my web page.
I am in the process of upgrading to Office 2007 Professional even though it
doesn't have FrontPage as part of the package. It contains Publisher.
Question 1: Will Publisher function as well as FrontPage?
Question 2: Should I totally remove Office 2000 from my computer, and
reinstall FrontPage 2000 and then install Office 2007?
Question 3: Should I just install Office 2007 in conjunction with Office
2000 and let them both reside on my computer t...VBA
Greetings from Norfolk
I am trying to create a 'accounts' routine that allows the user to select
first (A) what they want to do (enter sales, monthly account etc.) then (B)
to select the month that they wish to work on.
I used buttons to select the first (A), then the macro that runs from the
button (common to all three butons) to display the list box (B) to select
The problem is that I cannot find a way to save the information on which
button has been operated to start the process. The macro that runs from the
button (A) does not connect with the macro that runs FROM the p...Help sending email via windows live PLEASE
Have been using windows mail for months last few days i cant send email i
really need help sorting the problem the full error code is below please help
its doing my head in and trying to get a engineer is difficult
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems sending e-mail" section. If you need help determining
the proper server settings, please contact your e-mail s...Help with a formula please
I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003
"Matt Stone" <firstname.lastname@example.org> wrote in message
> I need to count a number of text cells to find out if an exact same
> occurance occurs more than twice.
> I Use Excel 2003
> Any ideas
works in xl2k. lookup countif in xl help....USage of Substitue product please help me!
It is my curiosity and limited knowledge made me to ask this question. what
is the usage of substitue product in crm. I didnt find any speciality in the
case connecting it to opportunty, Quote, And others. Any know its practical
usage plese help me to know about it. I am looking for ward some
functinalities to packes the product, and select the different products in
the package on opportunity area.
Advance thnks for any help
I am new in SBS 2003. trying to study myself. pleas ehelp me
...Help with code please
How do I change the code below to look this range up on a sheet called "
Private Sub UserForm_Initialize()
UserForm1.Caption = Range("A1")
Thanks in advance
I worked it out
Thanks any way
...Please take a few minutes .....
Please take a few minutes to complete the Social Media Questionnaire
for my research paper.
Opne following link of Questionnaire
Thanks & regards,
...Mariano Gomez : Please contact me
Hi Mariano, I'm Tom Archer from the Microsoft MVP program. I'd like to
request you contact me about an MVP award nomination. You can reach me at
email@example.com (remove "online") for more info. Thanks!
I replied to you from my personal email.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"Tom Archer [MSFT]" wrote:
> Hi Mariano, I'm Tom Archer from the Microsoft MVP program. I'd like to
> request you contact me about an MVP award nomination. You can r...