I just wondered if anyone knew a way to save various auto filter
combinations in excel to allow easy access to a set of results. It
would be useful if I could keep a complete list in an excel workbook
and quickly amend the searches to highlight a subset of results.

I am working on a conditional formatting formula that will refer to a
different worksheet that the one it is in, I hope this can be done, so
here's how the formula needs to be:
in cell X2 of worksheet "10 DAY AVERAGES" I need a formula that tests

I have data that I dump into Excel through Microsoft Query.
The data generally looks like this (in columns), in a sheet called
Data_Dump:
Date                  Stock_Name       Return

Out of the blue, my brother says mailto links and urls no longer work
from within an Excel spreadsheet. i.e. click on the email address & it
should open the mail client. He gets an error message related to
security saying go to the administrator. I guess this is a security

I've created a billing register for a client with the "Date of
Transaction" in column A (A8:A508).  At the top of the sheet, I have a
cell with an "As of" date value.  What I need this cell to do is read
column A and find the last date entered.  I've tried an array function,

I'd like to make a menu page with buttons to jump between spreadsheets
of a workbook.  I will turn off the tabs at the bottom in order to do
this, but I'm looking for code for my menu buttons to flip to each
spreadsheet.

does anyone know how many copies of a file can be opened read only in a
network environment? Or is this unlimited?
Best Regards
Mike

HI guys I was wondering if you could help me with writing a formula that
meets this criteria...
1. I need to combine Text in column A to Column B (=A1&B1)
2. BUT I only need the first letter of coumn A to combine with the rest

Having an issue with File Locks in Excel.  The dialogue box that informs you
the file has been locked doesn't tell you which user has the file locked.  
Making it difficult for the users to sort out and make their changes.
I've found a lot of posts and web pages that address the ...

We have a huge spreadsheet containing various pieces of information about
files.  One of the columns contains a date.  The column is formatted as
Date.  However, for some inexplicable reason the date in this column is now
showing as just digits.  If you double click on the cell ...

I've got three team, A, B & C. Each team has a goal each month. I'm graphing
their actual values against their goals. I've got their Goal bar colored
blue. I'd like to color all the bars that are less than the goal red and any
bars equal or greater than the goal colored green. Is ...

I have a spreadsheet with column headings.  Several of the columns need
to be split.  How do I do this without splitting the heading?

I have a series of excel documents being sent to me over a period of
time, and I would like to import this information into one sheet
automatically.  The documents being sent to me are all identically
designed, so importing is no problem.  

I have a master worksheet with all of my data... about 200 rows worth
of items and 10 columns of information about each item.
I am trying to write a formula that returns an entire row of
information based on the value in a column.

This is a new program on our computer, Is there no longer a toolbar with the
options of "bold" highlighting or font size or type or underscoring?