I've been able to insert hyperlinks to certain places in a Word document by
using bookmarks, but so far I've been unable to hyperlink to a specific page
number.  I don't want to create a bookmark for every page, so I'm trying to
generically reference a page.  Some web postings ...

I have 2 columns: A has dates (appointment dates), B has integer numbers
(current waiting times in weeks).
I basically want to do:
COUNTIF A1:A20 > 30/06/2007 AND B1:B20 >6

I have a pivot table that is linked to an access query for the data.  I'm
attempting to get a macro that will refresh the data after some data in the
excel sheet is changed.  The change is linked into a table in ms access and
the query uses that table to calculate.  If I just hit ...

Dear Sir,
I am working with a very large workshhet A1 : M64000.
I can go from cell A1 to cell A48,000 easily by entering cell address at the
top left hand corner of the Excel Worksheet.

I need to delete every second row in my spreadsheet - the rows are blank.
There are 30,000 rows so I don't want to do it manually - is there an easy
way to delete every second (or every blank) row?

I have a spreadsheet from a query with various columns of numbers and letters.
If I do a custom filter on the column with letters, and, say,"does not
equal" a certain letter, the filter will work. If I do a custom filter on any
column with numbers, the same filter will not work. ...

How do I create a basic template where I simply insert columns between
existing data. Have never done a template before so not sure how to start and
if data needs to be imported.
Thanks for any help

I have been reviewing previous questions and answers and wasn't able to
locate the answer to mine.  If someone could please assist me that would be
greatly appreciated.  I have provided the problem below.  When I insert a row
under a3 the formula is not automatically incorporated ...

Would like to set up a formula that returns a value if the date is 12/31/??
and another value if it is any other day of the year?

I am having trouble with a subtraction formula, Hoping someone can help.
A2 is -200
B2 is 100
C2 needs the formula

Excel 2003 SP2
WinXP Pro SP2 1.5GB RAM
The standard Excel mapping doesn't seem to easily accommodate this, unless
I'm "lost in space..."

Can you please tell me how to get the values (source) in the drop down of a
combo box when the combo box is created on the sheet.(i know how to do this
when the combo box is in a user form)
Thanks

I just installed Office 2007.
This is very silly, but I can't find the Pivot Table command in the new
"ribbon" from Excel, and I can't see the traditional menus.
I had to personalize the quick access toolbar in order to be able to create

I have a database in excel for my collection of books which contains various
columns, title, type, cost etc. In excel 2000 when I wanted to add a  new
book I just clicked on form and a box opened with all my column names in it
and I just filled in the new data. In Excel 2007 I ...

Can anyone help in sorting data using colors...
(would be a great help if this can be done without using a macro)
Thanks in advance
Jithu