I have the following macro attached to a button on "Sheet2". User input is
gathered in certain cells on "Sheet2" and then via the (recorded) macro
transported to the Criteria area of a list for Advanced filtering. It all
works fine - except there is a whole lot of screen ...

I am using a countif to cout how many times something is appearing in  a
column.  I need a code that does a dual column count.  example: if column c
says tom then go to column g and count if it says red.
Any help is greatly appreciated.

how to transform a number into a date?

When I use batch FTP to send a file from the mainframe ( flat file ) to a
server as an .xls file, I get three columns of data in the first cell ( A1 ).
I would like to know if there is a way to get each of the three pieces of
data per line into three separate cells ?  The data ...

I have the following problem
A             B
AUD       1
CAD       2

has anybody any idea of how to somehow highlight or show if I have the
same value twice or more times in a column?
For instance
1 Tom

How can I use OR operator in the SUMIFS function?
I have 4 columns:
Value       Pay Period     Supplier      Type
100          9                       Local           L

How do I insert pull down menus in an Excel Spreadsheet?

i'm trying to create a spreadsheet with the following:
If C:3=NEW, THEN I:3=H:3+15 (I:3 AND H3 are in date format)
If C:3=RENEWAL, THEN I:3=D:3-35 (again, I:3 and D:3 are in date format)
Would appreciate anyone's help!

I have four worksheets in a spreadsheet and the first sheet his a summary of
the totals from the other three. I would like to have the total on one
worksheet also appear in its proper cell on the first worksheet. In other
words, I would like to have a cell on the first sheet ...

I have a strange situation. Excel 2003, I convert dbf tables to cvs and then
to xls using the ABC converter. When I attempt to use a text function (LEFT,
RIGHT, MID, etc) to find a string the function will not recognize the string
or partial string. Secondly, I insert a column ...

I have 4 columns:
Col B indicates if Trained - Yes = X, No = "" (blank)
Col D indicates Phase 1, 2, 3, 4, 5, or 6
Col E indicates Back-Up Phase 1, 2, 3, 4, 5, 6, or "" (blank)

To explain my predicament:  I am the manager of a football team.  I have 2
workbooks, one for player appearances, the other for player goals.  On the
'players goals' workbook, I have the position the player is in our all-time
goals list, their name, number of goals scored, I have ...

I need an inventory sheet that uses the workday, holiday and month formula
and I can't get it to work.
A1 has the date
b1:m1 have workday weeks minus holidays.

I am working on Excell 2003 and I have applied a format to a cell, I can see
the formatting in the formula cell but when I hit return the cell will not
update to the format applied.
ie. Formatting for a date, I have applied the format to the cell and the