How do you specify a hyperlink to a specific worksheet within a workbook.  
The excel file in question has been saved as an htm file.  And actually, this
excel file was created from a macro that is outputting date from MS Project.  
Each workbook (page) within the htm workbook is ...

I need to compare cells to the cell above them and to the right of
them.  Based on the comparisons I'll need to update the original cell
with one of those adjoining cell values.  After I finish with one
column then I need to repeat the procedure on the column to the LEFT

I want to align all cells to the left side of the sheet.  Example, some rows
have entries in the middle of the speedsheet with no enteries in the
beginning.  I am sure it has to due with the formating, just don't know how
to do it.  Any help would be greatly appreciated.

I am developing a spreadsheet to show the date and time an event has occurred
at a location.  The cells indicating date and time are custom formated to
display mm/dd hh:mm.  The first occcrrence is shown in column G, the second
occurence in column H, the third iin column I, and ...

I'm using Excel 2002. I have 2 windows open, doc1 and doc2. I select a row
thereby highlighting it in doc1. I click in the the doc2 window to make it
the active window thereby causing the doc1 window to become inactive. When
the doc1 window becomes inactive, the highlight on the ...

I've a column of numbers (B4 to B56)...
What I want to do is to check each Cell and IF it is LESS than 20, add up the
number of CELLS (not the cell value) that are less than 20... and vis-versa.
Not all cells have any number in them initially.  This is a table which gets

I have added a checkbox from the control toolbox.
Then I grouped a bunch of rows.  starting above the checkbox.  to below the
checkbox.
However when I close the group, The checkbox is still there.

How do I connect a cell from a masterpage to another cell on a second page?  
The code that I was using, =Master!B4 , works, but shows a number zero on the
second page. I do not want it to do that. Any suggestions?

Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a
mini-database with names and addresses, etc. to feed into a Word 2007 mail
merge. Typing in all the data in the Excel worksheet is going to be tedious.
I'm wondering if there is something equivalent to a "form" ...

I am writing a macro to find the special char in the Balance
column(ie. only Numeric format)
Its finds and changed cells interior color on the particular column,
whiever cells contained specl.

    A                  B
1    DATE       AMOUNT
2    4/10/2006    $36.52
3    2/16/2007    $45.12

I frequently will do an IF test and if the IF test fails I want to
leave the cell unchanged. What I have done in the past is as follows:
=IF(C1>A$1,C1,"")
where the "" puts a null text string in the cell, simulating a no

How do I setup a stats (sum, count or whatever) on the same page as
the data and yet able to sort the data at will?  If I add a count, for
example, at the bottom of the data, and sort, the "count data" becomes
part of the sorting!!  Is there a stats that can be setup like a page

I am not familiar with this process, but how do one do a summary count
of a column?  i.e. how many "1" is column A, how many "2"s, "3"s...
Column A
1

i have Ms-Office 2003 installed on my system , Excel application shows 6.5
version of Visual Basic . I need 6.4 version of Visual basic for my
programming.
Can anyone tell me how to uninstall 6.5 and install 6.4 or how to revert to