I have Sheet1 with different names in a column.
In the Sheet2 I have to type in the names in certain cells. What can I
do that I don't need to write the whole name again but after I beggin
typing excel would check the list of names in Sheet1 and help me to

Hi Experts:  I've done this before but it's been quite a while and I'm having

I AM DOING CAREER STATS FOR PLAYERS. EACH ROW IS 1 SEASON, WITH A "CAREER
TOTALS" ROW BENEATH THAT, USING THE "SUM" FUNCTION FOR EACH COLUMN. WHEN I
ADD THE LATEST SEASON ABOVE THE "CAREER TOTALS" ROW, THE "SUM" FUNCTION DOES
NOT INCLUDE ALL OF THE ROWS ABOVE IT. IT USUALLY ...

Hi, good morning everybody
I need your help! I have a list and I like to use it like this. Colum A =
Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of these products are
in cells B2:U18 . When my costumer is asking me a list – for example $40.00

I have a worksheet as a result of customer surveys but the customer is
allowed to press * to skip he question or leave blank, how can I get the
percentage for the calls and exclude these numbers?
example

I want the worksheet to be protected, primarily to prevent users from
disabling validation.  But, I also want users to be able to copy/paste data
which negates the validation process (ie., they don't get the error message).
If I could enable formula auditing (specifically 'circle ...

I have seen the use of the following 2 versions of VLOOKUP and would like to
know the difference in the # of cells searched:
A.         "=VLOOKUP(A6,'PPR Data'!B1:J10,9,0)"
B.         "=VLOOKUP(A6,'PPR Data'!B:J,9,0)"

I regularly import data from another program with part numbers identified in coloum A as:
R/RVI/0444
R/RVI/5362
R/VOL/3699 etc.

Can I link the worksheet tab name to a cell so that it automatically updates
the tab name accordingly ?

I am trying to create a formula that will “count” a set of given numbers.  I
want to hand out numbered raffle tickets and have the ability to track how
many are given to each representative of my group.   The issue is the numbers
printed on the tickets are large and each member ...

I want to omit the right part of a text string that starts with "(" and ends
in ")" while returning the left part of the text string. I would have a cell
that contains a name such as "Lysell, Kent". Right after this name a number
in parenthesis is concatenated. For example, I ...

How do I make the last formula times by 1.5 then add all formulas togethe
=IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F6>0,(VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F6,""
=IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K6>0,(VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K6,""
=IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P6>0 ...

I am trying to automatically add hours weekly from date.
IE:  1/11/2008   hours 56.21 + 2.31
           A1                    B5
would like to automatically update hours on a weekly basis.

who can help me:
i have a data sheet with customer orders and production months.
how can i make report in which i can count:
a: orders per customer per production month

how can i make an event macro to update the value in C3 when a new value is
entered in B3 without the need to click an update button.
thanks,
fryguy.