a.  The only way I'd know to do this would be to add an extra row to the
header row of which one cell would add up the totals of a column, filtered
and unfiltered.
b.  I imagine, though, from using filtering in other workbooks, that it will

I have two columns in a spreadsheet "Quantity" and "Item".  I filter
the quantity column to select only the "nonblanks".  After this step I
want to copy these two columns and paste them into a Word document.
Once it's in Word I want to insert a column to the left of the

Ok. This one has me stumped. I have adding the compatibility pack to systems
in my office with no problem, until yesterday. Added the pack to an Office
2003 Pro system. Everything works great except for Excel. Now when we start
excel it acts like it is trying to do an initial ...

Let's say I have a range A1:T1 . How can I do a lookup which returns the
first non-empty cell, irrespective of the cell's content.  And by
'first' I mean the first as if reading left-to-right - so if M1 was the
first cell in the range (left-to-right) not to be empty that value ...

What I want to do is set up a Workbook with Sheets N01 - N30, and have an
index Sheet such that when N01 in the index is overtyped with 'Fred'
Worksheet N01 is renamend 'Fred'.  This way I can set up formulae etc which
will auto update as and when Sheet names are updated.  Is ...

I've reached the point where I'm loosing eyesight and need something more
than the magnification options Windows offers. The only suggestion I have
had so for is ZoomText and I am now testing it on my machine.
I'm wondering if anyone has any experience with ZoomText or any other

Item    Rate1    Rate2    Rate3
A    3    4    6
B    8    5    23
C    56    5    78

<I had posted that in vbasic newsgroup 3 days ago but I had no response>
==========
Talking about:
Private Sub moExcelApp_SheetSelectionChange(ByVal Sh As Object, ByVal Target

I want to highlight entries in a table that occur in a seperate list.
My table looks something like this:
A  B  C  D
E  A  F  G

SheetC has a lookup value in cell A3
I need to use the VLOOKUP with condition at cell G21 in sheetC in a way
that:
If range E21:F21=2 put the value (in G21) else put ""

I am trying to create a Pivot Table to show the WOS (weeks of stock)
by week over 2005, 2006 and 2007 for certain product families.
WOS = OH/AWS where OH = On Hands (available data) and AWS = Average
weekly sales (also available data). I did the WOS calculations myself

I'm sure this is simple for lots of people, but I can't seem to get it.  I
have a date generated by a formula.  I need to see if this date is in a list
of dates.  I tried MATCH, but I couldn't make it work.  I looked at VLOOKUP
in the Help file, but couldn't see how to make that ...

I was wondering if someone could help me with an Excel function.
What I would like to do is automatically merge some cell data:
For example, i have a csv file with columns, infoline1, infoline2,
infoline3 etc..

need to enlarge the size of the "name box" and Contents of cell" inorder to
edit without using "F2"

How do I make all the existing formulas in a worksheet appear on it, instead
of the resulting values?
I opened a worksheet that have looks this way, but I don't know how it was
done.