I am trying to search a word doc and change all words "test" with
"done", all from an excel macro.
I know there are shorter ways of eliminating a lot of text in my macro
(with , end with etc) but for my learning purposes now I would like to

I need help with creating a formula.  I want to count the total numbe
of individuals who meet a certain criteria in one column and a certai
criteria in another column.  For example: I want to find out the tota
number of people who live in Germany and went on a specific trip.  Fo

I have just found out that Pivot Tables keep a history of old data and
includes them with the new ones in the list for that particular data
field, and because I only want the new data - I have to manually go in
the drop down list for that data field and uncheck the old data so that

I am using the following function on a cell:
Format([cell], "hh"mm)
When the cell contains 06:00 the next day i.e. 30:00 the function
returns "01:25". When the cell contains any other time (even 29:59 and

how do u do a fill down?

I have a problem to make simple countif formula for more than 1 category.
Suppose I have an array of data in B2:B50 which has value (1 to 9). I want
to count the number of value with categories where the value is equal or
more than 1 and equal or less than 3.

I am trying to set the Macro security level to Low in Access 2003 but cannot
find the option in the Tools\Macro menu. It is not even grayed out. The
install is a complete install of Office 2003 and I tried a Detect and Repair
without luck. Any suggestions? Thank you.

Here's my excel quesiton.
Attached is my excel file.  As you can see I have a row marked 'weddin
date' so I'd like to sort ALL the columns (intact of course) by weddin
date, so that I can see the weddings starting from the earliest weddin

I am fine with just pointers where to start to look and learn how to do
this.
In some excel documents I downloaded I have seen point-n-click
drop-down-menues. It can be such simple as:

I want Excel to resize cells, based on the content I put in them,
automatically.

I have tried applying several different shading colors to a column of cells
in an excel 2003 spreadsheet.  According to the Patterns tabs of the "Format
Cells" dialog the last color tried has been applied, I just cannot see it
(or any of the previous colors) on my spreadsheet (in ...

Why do some of my Excel Workbooks open in "Shared" mode when I am the only
user? How can I prevent Shared mode?
Thanks,
Keith

I have 2 columns. Column A has values (numbers for the taxlots o
interest) that are not sorted in any order. Column B has the sam
values plus a bunch of extraneous values that do not appear in column
(numbers of other taxlots in the city). Columns C-G have values tha

Is it possible to copy a column of external data to a row in worksheet?  The
column is numeric data from a financiial website source and I want it entered
into my worksheet as a row with the same number of cells.
Currently I copy 5 columns of 10 rows of data.  I drag the 10 items ...

I have a funny situation. I have several users sharing a spreadshee
from a mapped drive. They each have a shortcut to the file on thei
desktop. When one opens it, makes a change and saves it, another use
then opens it and does not see the change. If this second user the