I'm trying to use one sumif formula to capture YTD personel info from several
tabs (Jan-Dec) within a workbook with no success.  The criteria is the
personel name. Because people come and go from the company the data can't
simply be pulled from the same cell from the different ...

I have in column K through W, column of data . The column heading is in
row K3:W3. In cell Y3 is the heading of a new column that the user will
enter. What i need to do is to find the matching cloumn heading from
K3:W3 and copy all the data from that column to the new column. Anyone

Hi, I tried searching for an answer to this but couldnt find the one I needed.
Apologies if I missed it.
I have data in cells B2 thru E2 on sheet 2 of my book. (eg, truck, red,
100Ton, petrol)  that is all selected from drop down lists.

I want to format the font color in cell G82 by checking the value in cell
D82. The value in cell D82 can be either blank, CAER followed by digits or
COR followed by digits. The formulas I wrote are:
Condition 1: =D82="" ; red font

Coworker just converted a 1-2-3 spreadsheet into Excel workbook.  Onl
thing that didn't convert was the 1-2-3 @ function for the date.
I need to show the percentage of the year that has elasped from th
start date of 10/01/05 to a date that I provide = % of year elasped.  

Hopefully this is just a quick question, I swear I have done i
before...
I need to do a formula that will calculate all values in the cell rang
that the text is not red.

Hi, I am trying to make this spreadsheet, I work for a clothing
manufactorer, I am based out of Honduras Central America. We have
multiple sewing lines, and they produce a certain amount of peices by
size, and by individule "PO's" purchase orders, the individual sizes

To all experts,
Please could you help me
i have a list of people( more than 1 entry for the same person)  in column a
and and a number in column b

I have one worksheet called "Main" which contains instrument details
and recalibration due dates.
Individual instrument details are called up to include location code of
where they are in the country, from a combo box and displayed in 6

I have a spreadsheet and in one column in says 66.5 - that's the time it
takes me to run x amount of miles.  I did a formula to divide that answer by
60 because I want to show the answer in hours and minutes and it comes out as
1.11.  I gather the .11 is part of an hour but how ...

How do I copy the cells A9,B9,C9 and D9 to A16,B16,C16 and D16 when
press the key (F9) ? Afterwards I type new data in the cells A9 till D
and press again (F9), then I want that the stuff from A16 till D16 go t
A17 till D17 and A9 till D9  again to A16 till D16.

how can i unprotacted worksheet whan i forget password

I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.
I have something like this (VBA Code):
...................

Please send me how to convert Rs. 1234.00 in Displays the number in text.
(One thousand two hundred thirty four INR in English text)
i getting in Baht in Thai Text but i need in English. How do i get it?
i am also using [=spellnumber(b14)] function but this function working only

I have a workbook set up with a sheet called "Tracker", with columns
set up as:
center#   firstname   lastname   centername     city        state  zip
   country