Hi - I am am hoping some genius can help me with my excel problem. If
you can, many thanks, in advance.
I have two worksheets: One which has a list of securities, trade
dates, and dealt prices (with blank rows between securities -not shown

In case the users I will be sending my sheet to, don't have their pivot table
selected, how can I insert a command button that refreshes data, without them
having to select the red !
Thanks

Is there any way to extract the detail listed in drop down auto filters?
I work with files where there are numerous entries of the same customer name
for each customerustomer in the one list along with other data in the file.
When you select the drop down box in the auto filter ...

I give support to blind people who want to use Excel, and publish documents.
When they enter data wider than the column width, of course the blind people
cannot see that the entry is truncated by the entry in the cell immediately
on the right.

I have a worksheet that has 2 Header rows. The second row is blank to
give the sheet a cosmetic look. The first data row is row 3. When I
select the sheet and do a sort the second header row gets sorted as
the last row so that the first data row is now row 2.

This problem has started to appear for sometime now. Everytime I start
MS Excel, it opens one particular Excel file saved in my documents by
default.
I hope your would be able to help me how to overcome this problem.

I use the Italian version of Excel. If I enter a date in a cell and I select
a format that shows the month name, I get the Italian version of name, for
example
martedì 16 ottobre 2007

I was wondering if there is a way to separate the following:
I have the following:
TX;CA;NM;VT;NY;MI;OK;FL
I need it to be:

Hello, I have these two monster formulas that I want to add together to get
a grand total of time.
One is:
=YEAR(C9)-YEAR(C8)-IF(OR(MONTH(C9)<MONTH(C8),AND(MONTH(C9)=MONTH(C8),

I need a function that will report unique records from a
database. It needs to do pretty much what the "Advanced Filter"
command does when it copies data to a new area and the "unique"
box is checked.

I'm having problems with preserving format of a pivot table.
That's how it happens:
- I clear all the filters
- change e.g. font size of the first column

I recorded a Macros & modified slightly to select the last column and last
nonblank cell in that column, but I would like to know how to find the last
nonblank column and last nonblank cell in that column to sum all the column
after the header.  Below is the coding that I have:

Excel 2003 under Windows XP SP2
I have two cells A20 and B20 both contain date info provided by a popup
calendar routine.
It is necessary for the date in B20 to be greater than that in A20,

Can anybody help me with a dilemma I have in excel. It all revolves around
calendar dates, dates from and dates to and dates in between.
What I am trying to do is construct a spreadsheet which will show me a date
in the future from a date I have entered.

Excel 2007 - all i want to do is select "one cell" on
a worksheet and EVERYTIME i click inside that particluar cell the
adjacent cells (sometimes also above and below it)  are highlighted as well
and i cannot stop it from happening.  IT IS DRIVING ME CRAZY.  certain cells