Thanks for all the help on Year-to-date query!
It's so great to know that there are folks out there that can take the
time to help someone whose 78 year old brain is slowly turning to
Francisco 9 @ ATT N E T
...Line graph help!!!
Hi, I need help! I'm trying to create a line graph of two separate sets of
data (each in the form of x,y) forming a graph with two different lines, one
for each set of data. I really don't know much about Excel so any help would
be greatly appreciated.
Assuming that you want them as 2 separate lines the best way to set up the
X Y1 Y2
A 2 5
B 1 3
Each adjacent, then highlight the whole set of data and click the Chart
Wizard button on the toolbar.
"Stephen Colbert" wrote:
&g...Pls Help Me! Creating Chart
:mad: Hi there!
How can I create / prepare this kind of chart, so call "Waterfal
Chart" in Excel worksheet? (01 file attached)
davidtips's Profile: http://www.excelforum.com/member.php?ac...Need one help
I need some help that I am working in cousulting firm and we providing
solution to clinet as web base and mail base. We are microsoft ceritfied
partner and we using win2k3 ent. server on this server exchange2k3 and other
is win2k3 with IMail. Till upto now we are proving clients mail solution on
Imail base but now we are planing to charge more for mail solution and those
are interested to pay then we give them exchange mail solution. Now I having
one question in my mind is that in IMail I create diffrent diffrent domain
for different web site according to clients. Now o...please help #8
I am trying to switch info from one XP machine running
office 2000 to another XP machine running office 2000 and
I have a ton of Macros. How do I successfully move these
Macros in excel, so I don't have to recreate them?
if you have stored your macros in your personal.xls just copy thie file
to your new machine
Bob Garber wrote:
> I am trying to switch info from one XP machine running
> office 2000 to another XP machine running office 2000 and
> I have a ton of Macros. How do I successfully move these
> Macros in excel, so I...IF function help
I need some help creating an IF function. I have a list of salar
brackets e.g A 0 - 10,000
B 10,000 - 20,000
C 20,000 - 30,000
D 30,000 - 40,000
On a seperate spreadsheet i have different cells with peoples salarie
in. In a seperate cell underneath their salary cells, i have an empt
cell that needs to have the relevant letter in that shows which ban
they fall into A,B,C,D etc.
What i need is an IF function in the blank cell that will automaticall
come up when a persons salary is typed in.
E.g : - if i type in 24,000 into the salary cell, i want the blank cel
to then come up with ...Help with formula #18
I am WAY over my head here, and you all have always been great help,
so hopefully someone can help with this. I had someone write this for
me to use as an index at the top of a spread sheet. It works
beautifully . The problem is I would like to move this index to sheet
2 of the same spreadsheet and when I copy and paste it, it does'nt
work. Is there anyone who can modify this to work as an index in
sheet 2 and will search sheet 1 for the results?
=IF(#REF!="","",IF(ISNA(MATCH(#REF!,$H$31:$H$65536,0)),"",HYPERLINK("#"&C...Help with mutiple profiles / accounts
Hi there, I have multiple different pop3 accounts i would like to use from 1
profile, is this possible? Please help.
I have 3 different pop 3 accounts which i have setup. I also have 3
different data folders that the mail from each account drops into, this
However, how do I set it so that when I reply to an email from 'pop1' it
uses the pop1 smtp server and account details and when I reply or create
emails for 'pop2' it uses pop2 details (the same for pop3).
This was possible in outlook express, in the email window, there was a
simply a drop down from which...Help needed with Money 2003 files
Hi there, I've been using money 2003 for years even when upgrading to new PC's as I had the original disk.
I've just had to rebuild my hard drive and now cannot find the disk anywhere so cannot install Money. As you cannot now buy Money, I've tried downloading the trial version of Money so that I can access all the account details/balances but it says that they're not compatible with earlier versions of money.
Is there anything that I can do to get these files open or have I lost all my records for the last 6 years?
I'd really appreciate your assistance. Jayne
EggHead...Exchange Server Problem (I need help)
Hello to you all!
The medical clinic I work at has a network. We all have our own email
address. Mine, for example is firstname.lastname@example.org.
The problem is this. I can send out email as much as I want and they go
where I need them to go. However, when anyone attempts to send any of us
email, to our work, we don't get them.
Now we had experianced some MAJOR problems recently in the past to where the
actual IT lady had to set everything back up because things just went down.
So our email accounts worked without any problems. But now, we can't recieve
anything from an...MS Office Activation Assistant,HELP!!!!
HELP!! Everytime I click MS Office-60 Day Trial it opens Activation
Assistant for the 2007 MS Office suites, and it has 2 steps. Step 1 is
to request a trial key online which I have but i have many trial keys.
Not only that when I click on the Step 1 icon it gives me another trial
key already typed in the OEM key display area and it unlocks the 2nd
step which is
_Now,_click_here_to_launch_MS_Office_and_to_enter_your_trial_key__ so I
do but then it says "The Microsoft Office Activation Assistant was
unable to launch your 2007 Microsoft Office release. Please re-enter
your sele...Windows licensing question, please help.
I have 42 full time employess at my organization and 121 devices (85 fat
clients & 36 thin clients).
I am purchasing a new Windows 2008 server, running Exchange Standard to
replace an existing 2003 Exchange standard server.
I have an additional Windows 2003 server, running terminal services.
CURRENT LICENSES (FULL TIME EMPLOYEES):
45 Windows 2008 user CALS
45 Exchange 2010 user CALS
40 Windows 2008 TS user CALS
We hire a variable number of extra part time staff throughout the year to do
computer work. Some may use a thin clients and some may use a ...POS screen messed up, need help fixing it
For some reason on one of our registers, the POS screen is missing the status
screen at the top, the function key buttons at the bottom, and the customer
POS buttons on the right. the only thing showing in the POS screen is the
'bill to', 'ship to', and 'shipping information' boxes at the top, and then
the transaction grid. what happened, and how can I get this other stuff back?
> For some reason on one of our registers, the POS screen is missing the status
> screen at the top, the function key buttons at the bottom, and th...HELP!!! #3
First, I was unable to display my Outlook folder. I
couldn't go to Detect and Repair because I couldn't open
Outlook. I proceeded to scanpst.exe to repair the
problem. Now I've lost all my email messages. Did I lose
everything? How do I restore the messages? I checked the
box to save it in a file but where is that file? Please
help quickly. I run a small business out of my home and
need to find this info fast.
...Macro to Delete Rows if true HELP!
I got this code from another answer and it works ok when I call it from the
activesheet ("Agent Tenure") but I need to call it from another sheet named
"Terminations"... please help????
Dim myrange, MyRange1 As Range
lastrow = Cells(Rows.Count, "N").End(xlUp).Row
Set myrange = Sheets("Agent Tenure").Range("N1:N" & lastrow)
For Each c In myrange
If UCase(c.Value) = "TRUE" Then
If MyRange1 Is Nothing Then
Set MyRange1 = c.EntireRow
Set MyRange1 = Uni...Help Program Bug
When the money help program starts I receive the following error pop up:
"A Runtime Error as occured, Do you wish to Debug", Line 7, Error: Expected
Never Mind, I found the bug. My money file name had a apostrophe in it.
Apparently Microsoft did not take this into consideration. I simply removed
the apostrophe and all is better.
> When the money help program starts I receive the following error pop up:
> "A Runtime Error as occured, Do you wish to Debug", Line 7, Error: Expected
...HELP: CRM mail doesn't always register
When we send an e-mail via CRM, it gets logged fine within the
lead/opportunity/account. However when we receive a reply to a message, if we
delete it within a few minutes of getting it, it doesn't register in CRM.
Why is this? Thanks
...Still need help
Here's my last dialogue. I'm still unable to clear a cell upon Close
Thanks FSt1 !
I'm a novice and need further clarification.
The subroutine did not run as I received the Macro Disabled message. I
clicked OK, and next time I opened the workbook, I didn't get the Macro
Warning, but the subroutine apparently didn't run as the chosen cells were
I don't want people who use my workbook to have to deal with macro warnings.
Is this something that must be set on each user's computer, or can I set it
in my workbook so the subroutine automati...Meeting Requests Help
We have a user here at work that wants to send out multiple day meeting
requests at different times through 1 email request , is this possible , or
is there a way to make this possible through a script. Thanks
The user can create the items, insert them into an email with instructions
to click on each one (if all are required attendance) or click on one if it
is a multiple choice of single event times.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furio...help me with this forumla
I would like to be able to put a "y" in any cell in column "D"
and have the same cell in column "E" turn blue
can you help me set this up
Message posted from http://www.ExcelForum.com
Joe, this simpler formula worked fine for me:
I selected Column E (just click the column heading), then Format >
Conditional Formatting. Formula is: =OR(D1="y",D1="Y"). Then I set up the
"DDM's Microsoft Office Tips and T...Offline Address Book Help
I recently added another Exch2000 server and moved all users to it since the
original server had a corrupt store. I'm now trying to shutdown the old
server but when I stop the old public store I get an Offline Address Book
I went into the OAB container and changed the server to the new one, but it
still doesn't work. I'm wondering how to tell exchange to get the OAB from
the new server and not the old one. My outlook clients are a mixture of
2003,2002, and 2000. My server is 2000.
Will I have the same problem if I have customized forms as well?
Thx in advan...Help domain controller failed
I demoted a domian contoller the other day
then I built a new domain controller using the same name
All the roles were moved to my other domain contrller prior to the dcpromo
of the old dc
Now today I needed to bring up the demoted dc on the network to check some
settings and it thinks it is still a domain controller
Now my new domain controller is dead
the netlognon server fails
I am at wits end
need any help asap
"Thomas R Grassi Jr" <email@example.com> wrote in message
news:u85lCm%23aKHA.808@TK2MSFTNG...sorting or filtering data, need help #2
I could not get the VLookup to work :confused
aroe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=26909
post the formula you have tried
"aroe" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I could not get the VLookup to work :confused:
> ----------------...Heiarchy Flowchart Help
Hi, I am new to PP2007, and am trying to create a corporate org chart with
one parent and 89 subsidiaries. I first inserted "flowchart shapes" from the
insert/shapes but there are no connecting lines. I may need to add and
delete at some point, so was looking for something that will automatically
adjust. I tried smartart graphics, but cannot figure out how to properly
move them around. It wants to just create the chart in one linear level.
When I try to move them, they don't line up correctly. Can anyone help??
ALL lines act as connectors in 2007 but...Help me registering buy/sell Covered Warrant
How can i register a buy, a second buy, a total sell or a sell of a part of a
quantity X of cowered warrant in Microsoft Money 2008 ?
Example: I bought in date 04/20/2008 N° 1,000,000 of CW (Isin: JE00B1NX5L84)
at the price of U$D 0.023; i pay for that bought U$D 0.01% of commission.
I bought in date 05/20/2008 N° 2,000,000 of CW (Isin: JE00B1NX5L84) at the
price of U$D 0.026; i pay for that bought U$D 0.01% of commission.
Then i decided in date 06/01/2008 to sell middle of the CW: N° 1,500,000 at
the price of U$D 0.028; and i pay for that U$D 0.01% of commission.
In date 06...