I have created a form with drop down boxes on tab1 on tab2 holds a summary
of info and tab3 hold text and some calculations.
I want to hide tabs 2,3 and create a Button which will say calculate on it
which will then show tab2 and auto e-mail the woorksheet to some one

I need to make a hyperlink from a graphic to link indirectly to a cell or a
range of cells in the same worksheet.
The worksheet is alphabetized and I have created graphic buttons across the
top with the letters A to Z. The number of rows (1000+) changes frequently

I'm using the following formulas to count the number of specific
characters ($K$147) in a given cell and increment by 1:
In cell H74:
=IF($H$5=0,0,(LEN($H$5)-LEN(SUBSTITUTE($H$5,$K$147,""))+1))

Howdy.
One of my co-workers had his hard drive die on him. We took the machine to a
data recovery shop and they were able to get some of his files back.
According to their tech, the only way they could do it was to transfer the

I have columns of data comprosing of dates, "NA", and blanks.  How do I count
only the dates and not the "NA"s and blanks?  I pretty sure it involves
"counta" but this counts the "NA"s also.
Thought I saw something close to what I want but can't remember what

Please suggest a more compact format for this formula:
=SUMPRODUCT(
(INDIRECT("RawData!B"&$I$32&":B"&$J$32)=105)*
(INDIRECT("RawData!AA"&$I$32&":AA"&$J$32)="M6")*

I was wondering if there's a formula that would calculate a value based on
different variables.  Example:  If I had 4 diiferent values: 2.35; 5.09;
5.25; 3.25; 3.99 and I wanted a value returned that was based on this:  

need to add a 'select' & 'Group by' statement in excel query.
The Spreadsheet looks like this
KRE001    8/17/2007
KRE001    8/17/2007

I'm creating a spreadsheet which imports data from the internet. I've set
this up fine, but would like the data to automatically copy itself to a
worksheet whenever i refresh the data. I would also like it to move down a
row each time it refreshes, so i can keep a running log of ...

How would I create a workbook, where information from a pervious workbook
would filter into the new workbook automatically?

i'm trying to do 3 or 4 work sheets on the same work book, but i have some
common cells on all work sheets so i want to have the same cell for example
on all work sheets related when this cell changes on one sheet it changes
itself on the other sheets as well?

What I would like to do is add up hours shown within specific columns or
ranges on multiple timesheets. But here's the tricky part, to add up only
those cells that have all the same number (i.e. job no.)in a different column
within that same row.

Hello.  I'm trying to find a fast and easy way to have excel look up item
numbers listed on my orders (excel 2002) worksheet from the vendor's product
list and then copy the data found from the vendor's product list to a new
list so that I can import that data into my system.  I ...

How can I filter data to show the top 10 AND the bottom 10 items at the same
time? The Autofilter gives the option of one or the other but not both. My
data is set out as shown below. I've used a macro to filter using advanced
criteria for 'Sector' but I would like to be able to ...

I have formatted a cell for dates. When I enter a date it will put a = sign
in font of the date and will not display the correct date. it displays 1/0/00
as the date. How do I get raid of the = sign.