I have an excel sheet, the data is sorted by A column and A column holds
three values, Patient, Caller, Doctor and that are other columns that keeps
different data.  How can I build a macro that exports this whole sheet in to
three different files based on the values in A column. ...

I have a list of expenxe categories and by month along the top.  How can I
write the sumif function based on two criteria from drop-down list(one list
is Expenses and the second list is the Months) and the third (Amount) cell
would be where I input an amount to be added into the ...

Is there a way to get the list below to sort in time sequence?
Notice that the morning times are after the PM times on Friday.
You are looking at 3 columns here. date, hyphen and time.
Time column is formatted as time. Sort is in ascending order,

I have the following issue:
After exporting Crystal report file in Excel, I can't group the rows
in the exported file.
I mean, when I open an exported in Excel report, I can press the

We have an Excel 2003 spreadsheet with one column that has a series of
hyperlinks to a network drive that is on a different server than the one the
spreadsheet is on. After creating the hyperlinks. we are able to use them
and all is well. As soon as we save the document the links ...

Hello - I have created a dynamic chart that shows the most recent 12
months of data.
So, for example, one of my series value sets is based on the defined
range:

Uing Vista SP1 and Office 2007 SP1, and working on files which are
synchronized to "offline files", there's a bug in Excel.  I'm comparing the
behavior to Word 2007 which appears to work correctly.
The computer is online with the server at the time of this test and the .doc

I'm unable to find any kind of information which will helpful me for MS excel.
I want to work with Excel. But i have not enough knowledge about it.
So kindly send me immediately for something it may be in pdf, .doc, ppt
formate which is helpful me to assist for MS excel.

I have a excel sheet that I must email and I want to setup a hyperlink within
the sheet so that I can click on it and it will automatically bring  up my
outlook and attach the file.  I have an hyperlink now in the sheet but it
will only bring up the email and put in the address ...

In Excel2003 I have some information at the top of a page like company name
address etc... and one of those needs to be an account number. But the
problem is that the number is something like 0000486565 and Excell keeps
dropping the first set of zeros. I looked in the formatting ...

All,
How to me excel to give an error message on a conditional format?Like for
example if a cell is greater than 365 besides giving a red background as it
is conditional formatted, it also should shoot an error message in the screen

In Excel 2007, how do I split one cell into several rows?

I am wanting to get excel to keep track of my gross earnings through out the
year
I have my pages set up but I can not find a formular that will retain
previous amounts and add new amounts to it like a year to date thing but I

Please could someone help me with a query that I have.
I have a spreadsheet, which on one sheet contains a whole load of data by
region, which I am trying to summarise.
On another sheet I have set up a summary table that I want to populate,

Excel 2007
I want to sum a column that each cell has a number or text in it based on
the conditions of that cell having a number and the results of other arrays.
I keep getting #value error even though I use the double unary (--). Can I