when I program a link to a file , for example "file:///C:/test.log" in
the cell, I get an pop up warning "Hyperlinks can be harmful to your
computer and data.......". So everytime when I try to open the link, i
need to close all the pop up windows one by one.

I have two worksheets in a spreadsheet with similar values in Sheet 1 Column
A and Sheet 2 Column A. I would like to create macro that would match like
values in column A in both sheets and copy the entire row in Sheet B to Sheet
A.

I have an attachment that's apart of this message & within it I have 3
tabs 1) Revenue 2) Expenses & 3) Net Position. I would like to do some
Analysis on the above three thou a way where I can manipulate the Data.
How would I go about doing this? I've tried a Pivot Table thou it ...

I have the following data
    phase 0            phase1     phase 2            phase 3    phase 4
A    1/1/2006    3/3/2006    5/5/2006    7/7/2006    9/9/2006
B    3/3/2006    5/5/2006    7/7/2006    11/11/2006    3/3/2007

I need to import a text file into a spreadsheet. I can do this manually by
doing File > Open > then select a text file. Then Excel goes through the
Text Import Wizard
I can automate this by recording a Macro in Excel. The macro looks like this

I need a formula that averages A1 through A31 and need to ignore blank cells
in that range that contain formulas that reference data from other sheets. I
need it only to average them once they populate with data. Thank you if this
is possible.

I am using Excel as a database, and have a column with cells with a person's
name (text) in it...e.g., John Smith.  NOW, after the fact, I wish to have a
column with just John in it, and another column with just Smith...but I have
NO idea how to do this!  Help would be ...

I want to view my Excel workbooks in separate windows (I have 2
monitors and want different workbooks displayed in each). Looking
around online it seems the setting to allow this is:
Tools > Options > General > Ignore other applications

When using data filter advanced. How does one filter, when the criteria
wants data from one column only when another column is blank.
I have tried ="=""" for the blank column, but it does'nt work???????

I am using Excel as a database, and have a column with cells with a person's
name (text) in it...e.g., John Smith.  NOW, after the fact, I wish to have a
column with just John in it, and another column with just Smith...but I have
NO idea how to do this!  Help would be ...

halp me i want laren abut Excel pales som bady halpe me

Is there a way to suppress display of procedures in the macro window the
user can run from the Tool menu from Excel?
I can't make the subs private since they are in a general module and called
from worksheet event procedures.

I have a column that contains cells that have either numbers and letters, or
nothing at all, what I am trying and failing to do is add this column, not
the contents of the cells but a total number of cells that actually contain
data, for example if there are 40 cells in a column ...

I have Office pro 2003 oem installed. When using Excel I occasional get a
small green triangle (error notification) appear in some cells.  I know how
to turn off the green triangles via the dropdown menu that appears next to
the cell with the error.

Sorry, this may seem like an elementary question but....
First of all I have three seperate worksheets containing data within my
workbook.
I want to return all rows from each of those worksheets that matches a