I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this ...

Iam new to writting macros can anyone guide me please

I am attempting to create a time card system based on information entered
onto an invoice.  I have it set up so that a rate in column b is based on
which attorney is designated in column a.  I placed the hours in column c and
the total charged in column d.  Is there a way to sum ...

I need to use the sumproduct function but I would like to exclude 4
particular items which occur in a certain field
eg
SUMPRODUCT(($A$1:$A$1000 = FT)*($B$1:$B$1000 = 1)*($D$1:$D$1000))

I have thousands of invoice most of them have the same invoice number. every
invc# contains crdt type and some of them are the same too but each of them
have the amount.
How to sort them to show no redunduncy of invoice and crdt type and the

In Excel 2003, the right click options list includes a research option that
pops up on me routinely.  It's very irritating, esp. if I am just about to
paste something because once the research window opens the paste option is
also gone and must copy again.  Any way to turn this ...

Hi, I need to write a formula that shows different names for different
months. Like, in column A I will have months of the year and column B I will
have a scientist name. For “odd” months (Jan, Mar, May, Jul, Sep, Nov), I
want scientist A, for “even” months (Feb, Apr, Jun, Aug, ...

I have 10 colums of dollar amounts and in column 11 I need a formula that
will tell me "if 7 of these columns are greater than 0, than yes, otherwise
no".  I would appreciate any help.  Thank you.

Stefi, can you help me with one last problem? at least i hope so....
It's about date formula...
=IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B5;"dddd");"YES";"NO")
Example:

I have formatted a cell in hr:mm:ss and have a number in another cell and
have inserted a formula in a third cell to multiply cells 1 and 2 together
but I am not getting the correct answer. Presumably I need to format one or
all of these cells differently.

I'm having trouble opening an Excel file.
First, I have researched this board.
I have made sure Tools>Options>General uncheck "Ignore other Applications"
is unchecked.

I have a data sheet that get entered with date and hours for the year.
Some days we might have several entries or just one, it depends on how much
work is done.
I have a table numbered 1 to 31(col A). They corespond to the days in a

Is there any way I can set up a message pop up when ever a file is opened.
Thanks
ahmed

Hello Excel experts:
I have one doubt in this following sheet:
        1997
EU (27 countries)        100

How can I list the most common word in a given range? I have office 2007, if
this matters. The range could all potentially carry the same value, or there
could be blank lines as well, so considering the blank line issue would be
appreciated. Thanks for the help!