I am using Excel 2002
Is it possible to place pictures in cells from file.  What I am trying to do
is find emblems for Baseball teams on the net and save them in some sort of
picture format ex. gif, bmp, jpeg etc. and then be able to load them into a

At home I have Excel 2007 but at work we use Excel 2003.
Excel 2007 now has a new function called COUNTIFS. (Counts the number of
cells within a range that meet multiple criteria)
Obviously when I send the file back to work it no longer works properly.

I have a worksheet that imports data using a data query from an Access
database.
The external data range properties are set to auto refresh the data
every 5 minutes.

I am trying to create a work book for a Call Out Response Call Register.
What this consists of is: Daily Reporting on number of calls made. This make
up of; No. of horses on property, no horses, ph number disconnected, invalid
ph number, no phone listing, already contacted, ...

My Data Range is (shortened for this example):
124    00A2RG000024CMNM      A2RG.CS.1.1.1    A2RG.CS.1.1.1.1
125    00A2RG000024CLTM      A2RG.CS.1.1.1    A2RG.CS.1.1.1.1
126    00A2RG000025CDGM      A2RG.CS.1.1.1    A2RG.CS.1.1.1.2

is it possible to make a formula (or macro) so if a cell from column "A" is
selected, then a cell from that same row will be copied to another sheet?
example:
A3 in sheet 1 is selected, D3 from sheet 1 is automaticly copied to wherever

Can anyone else recreate a similar error in the result of the match formula,
or am I doing something wrong?
the following formula is producing a result of 5, I would have expected a
value of 1.

I download weekly information off the web that has been formatted as text
strings.  I have set this up as a web query, so all I have now to do is
refresh the query each week to get the updated information. I also know that
some of you will just say use text to column function ...

I'm looking for a way to calculate a specific percent of a column of
different prices in different cells. Can anyone assist. I want to reduce the
different prices by a specific percentage for about 490 items automaticully.

I've been trying this with variations of the =MAX function but cant get it
to work... :-(
I have a row of text entries as column titles in every second column, e.g:
A1, C1, E1, G1 etc

Im using the =NOW() function to display time and date in my worksheet.
Could someone please tell me a few ways to format it to display differently?
e.g: Date only, time only, date first, time first etc
Thankyou if you can help.

Hey all,
How can I AUTOMATICALLY add a text string to a existing string when the
existing string is not constant?  I'm thinking maybe an IF function with
a CONCATENATE function? I need all strings to equal this format - 0d 00h

I have a cover page, Sheet1, with table of contents on lines A1-A7.  I want
to click on any of the cells, A1-A7, and have that corresponding sheet come
up.
Ex.

I started making a directory for my Business and I want it to be
alphabetical. I don't know how to get the columns to stay together. like if
Mr smith is on batless and and mrs allba is on surey how can i set them to
alphabetical and have all the info stay in on row when it sorts

I want to change the background color of a cell based upon the results of
different cell in the same row.  For example, if c5 = "" then c4 background
color = yellow.  Can someone help?
Frank Natalie