I'm working on a metrics log and I need to capture the current date and time
in the same cell and for it to remain static. I found a code on this website
but it only captures the time. I'm not familiar enough with this code to
manipulate it for both date and time. Can someone ...

I am trying to calculate the commision on sales using the percentages in
A1:C1 for each rep using the following criteria:
For new sales for Products 1 or 2, Sum B10:B12 and G-I0:G12 then multiply by
C7

In sheet 1 col. A I have many zip codes and In sheet 2 I have 5 col. A,B,C,D
are zip codes (They Do not match with sheet1 col. A) and in col. "E" I have
phone numbers.
How can I do a macro that compares sheet1 Col.A with sheet2 Col. A,B,C,D and

I want to make text effect on excel. For a example if I put some figure or
symbol into a cell, I want it to blink/shimmer or sparkle as in the case of
MS word. Can anybody help me?
Thanks Very Much

I want to create a document that multiple people can update at the same time,
and allow each user to save their changes (even if it happens to be in the
same cell).  But, I don't want the other users to be concerned with their
co-workers changes, just their own.  I want my ...

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.

when I go to print a document in excel my printer spits out about 3 extra
sheets of paper first. How do I stop this?

Excel 2007
Using Spinner Controls for a Counter function
Is there a way to seperate the Up and Down arrows from each other?
Is there a way to assign a color to the spinner control?

when doing calculations I want the answer toi  come out as a ratio 1: 25
rather than just 25 - I have found a way of doing that by adding the 1: as
text within inverted commas - but it won't allow a rounding.
Does anyone know another way of doing this pls??

Is there a way I can round time to the nearest half hour? I need to know how
many patients we take care of by half hour however, the data I have is by
minute.  It's ok to round up or down but the current data is in military time
mode if that makes any difference.

I am having a problem with an external link showing the path of the link
instead of the value. For example it shows ='[Sales
Forecast.xlsx]January'!A2. When I first create the link it shows the value,
but once I remove the absolute reference from the linked cell it shows the

I DID DELETE A SHEET, HOW CAN UNDO, AND RECOVER MY SHEET?

Can I create a mandatory number of characters in a field when creating a table.
Table 1
Field1 date
Field2 Time

We would like to both be able to modify a document while in the same file
(ie. make it more than just a read-only document for two people).

I need to get a value out of a range when I know the rank.  
I would like a symmetric function to RANK(value, range) which returns the
rank given a value in the range.
I can't do the vlookup type solution I see referenced in the other posting