I've looked around in the FAQ and other help areas - maybe I'm asking the
question wrong. (Not uncommon)
I have seen this done in the past - but I can't remember how it was created...
I have a list of room numbers - in a separate column I have a list of room

When I save my worksheet and then reopen it jumps back to the beginning of
the sheet, not where I saved it last
Help

Here I am back with another question.
I need an Excel Macro that will open "MS Word" with a blank document shown.
Secondly, I need an Excel Macro that will open "MS Word with a "Named.doc"
Please see the two codes I have tried.  Both will open Word, but neither will

Hi
I am using a 3D formula =SUM(COUNTIF(INDIRECT("'"&{"Apr 07","May 07","Jun 07"}
&"'!F27:F48"),({"<18","<=20"})*{-1,1})) to count ages between certain age
groups, but keep getting a 0value to where there are 8 references between the

For various complicated reasons I am using a macro to build a series
of "helper" named ranges which are named "Row" and then the row
number. (ie Row1, Row2 etc)
I can then use the following function in my worksheet;

I  am describing what I am  doing weekly since I would like to automate the  
following process. is there some kind of a script that can be saved that
would remember my key strokes and/or some other way to automate this process/
Right now I run queries on sql server and copy and ...

Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.
I have 12 monthly worksheets and a summary page
I want to get Excell to look in a column F on each month and if it has a

I am trying to create a spreadsheet with mulitple rows and columns.  I want
to have the header of the columns to be vertical to save space.  Does anyone
have the answer to this question.

I have already hidden rows (from the subtotal function) and I would like to
delete the hidden ones (ex. level 2 in subtotals).  How do I do this without
going line by line?

I have been looking on this discussion group for an issue similar to mine,
and I found a few, but not that were exactly what I need. Any help on my
issue would be greatly appreciated!
I have 2 spreadsheets, one with 15 columns and about 20,000 rows, the other

Hello, smart friends
After changing of reference data the autofilter option is NOT refreshed.
Is it possible to refresh the autofilter by activating the (filtered) sheet?
Thanks in advance

I want to limit the input order using custom validation. My case is as
following:
From a1 to a10, i want user input one by one in order, so I use custom
validation and my formula is =a1<>"" . after I clear the Ingore Blank, it

I have 7 values ie a, f, p, s ,t n and sl which are used within the
worksheet, i want to apply a pattern colour to the cell which a,f and p use
whilst a different colour for t,n and sl and another for n.  As conditional
formatting gives only 3 conditionals I can not use cell ...

I want to use the vlookup formula in a worksheet that contains several
results for the reference that the function Vlookup is looking for.How can i
make the function Vlookup search for all the results ( not only the first
rox) and make the sum of them?

I am trying to find a value between 3 sheets to find a total o numvber of
British person who have accessed the service.  The formula i am using is
=COUNTIF('Apr 07:Jun 07'!G27:G48,"British"), but all i am getting is a value
error.