I set up two lists, 200 employees names and 200 employee numbers. A couple
of the numbers match the correct names but the rest of the numbers all pull
the same employee name.
=LOOKUP(C4,List!C4:C204,List!B4:B204)

Thanks all
Double clicking on a .xls file within Windows Explorer opens Excel - but no
files opens.
Unless Excel is already open - then the file opens.

I'm somewhat new to Excel and want to do the following:
=IF(A2=B2, copy file named file1.txt to file2.txt, "")
Is there anyway to do that copy command in this kind of situation?
Thanks!

It used to be you could highlight a column, do a Copy and then, when you
selected paste, you were presented the opportunity to Transpose.  I am not
offered the opportunity to Transpose. What gives?

I hope the Excel mavens can help with this minor but galling problem. I  
have Excel 2003 running on Windows 2000.
If I use the format painter to copy the format from cell 1 to cell 2  
(e.g., change of font) it works as expected. But if I later want to alter  

On page setup, Header/Footer tag we have "custom header" that includes:
let section, center section, right section.
four line are printed in the "right section" the alignment is right
justified

this must be a common problem, and I thought I found the solution, but
it doesn't work ... I'm probably missing something very simple.
I want to execute a simple VB function in one cell, taking another cell
as Parameter. Both, parameter cell and function result are strings. For

To retrieve data from a pivot table the moment this table is changed I use
the code shown beneath. I thought it should work without problems, but it
does not. I really can't seem to figure this problem out!
I hope you can help me! Thanks in advance!

How do I get all of my data onto one page instead of two?

How do you make row 1 repeat itself in the worksheet? I.E. As you scroll down
the page, row one will always be at the top of the worksheet.
I can make it repeat itself as the first line on each new page, but I need
it be at the top of the worksheet as I scroll down so I can easily ...

I am using relative cell address in formulas. Ex:  =+F50+I50+M50   ...
I have 108 columns.
When I erased colomns I have an error: #REF!
I tried using obsolute reference without success

I am loading two excel workbooks.
I want to run a macro from the first workbook, but I don't want to complete
the macro code until the other workbook has finished loading
I am restricted from placing macros in the 2nd workbook.

I want to auto hide a specific number of columns depending on a
validation list selection.
IE, user selects a shop ID and columns D, E, F, G, are hidden because
there are 3 people in the shop.

I'm trying to round to the nearest nickel.
I have looked at the round function but can't seem to get it to work.
E.g.  If it's .38, the display is .40.  If it's 1.32, it's 1.30.
Thanks,

I want to fill a range with a color.  I know how to do that but I don't
know how to keep the grid lines visible in that range.  It seems I would
need a transparent color or something like that.
How can I fill a range with a color that will allow the grid lines to