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...Why does a drop ship PO need a Site ID for the line items?
What line item Site ID would I use on drop ship POs? On a normal PO, the Site
ID is where the product will be inventoried; for a drop ship, it will never
come into our warehouse so I'm confused why I would need to enter something
The address to which the vendor ships the product is put into the Shipping
Address ID (which makes sense)....I just don't get why you need a Site ID.
Bud Cool, Accounting System Manager
HDA, Inc. Hazelwood, MO
GP 9.0, SP2
The Site ID is a required field and you will be asked to enter one, even
when entering a drop-ship PO.
Best rega...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 email@example.com.
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...Newbie question
Is there a way to flag selected cell ranges to always stay
together when they print? In Word they have a "keep lines
together" option -- is there anything comparable in Excel
to ensure that selected cells/rows stay together on a page
even when new information is added (not only within the
selected range but also when additional cell ranges are
I need to ensure that the cell ranges aren't split by page
breaks. I currently use print preview to see where they
are breaking once I add new information and then move the
page breaks before printing.
Since new...need form template for excel
For the purchase and sale of real estate there is a standard "Settlement
Statement" following the guidelines established by the U.S. department of
Housing and Urban Development. This is a standard form with proratation and
allocations. Perfect for and Excel worksheet. I don't see it on your site and
wonder where I might get one.
Last year I custom designed a complete set of closing forms for a client
using only excel where all variables were entered on one sheet and
automatically transferred to about 15 forms with ONE mouse click.
donaldb@...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
...How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?
How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?
"DR" <firstname.lastname@example.org> wrote in message
> How to create a CLR DLL for Sql Server 2005? Is it just any .net class
> library that you can load into Sql Server 2005 or is there some special
> project type that I need to start with?
You can do it all "by hand" but there is a template "SQL Server project&...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...