i'm building a spreadsheet for the user and i need to make all the
drop-down arrows to be shows so the user will know exacly where he can
pick his choice,
is it posible to have this option becaouse for now the only way to

I have a crew worksheet made up with a large number of cells. This sheet
contains the shift rosters for our workers, which runs 24/7, on a 4 crew
basis.
1st column is the date, 2nd day-of-week, and 3rd onwards are the crew and

I need to have the value of a cell based on the number of days past from a
date in another cell.  i.e.  A1 = 40 if A2 [date] is <=today()+365 or, A1=80
if A2 is >=today+365 but <=1460.  The idea is anual vacation paid based on
hire date.

I need to copy a formula from column I to column J, and would like to do the
following:
Column I                         Column J
=SUM((APR!C4))              =SUM((MAY!C4))

How do I set up different colum widths for the same colums in different areas
on the same worksheet?  For example: colum 1, rows 1 through 5 are 20
characters, colum 1 rows 6 through 10 are 10 characters . . .

Here's a doozy:  I have a workbook with 12 worksheets.  I need to make a
workbook for each worksheet.  Each workbook will be named similarly with
the officer's name added in parentheses; (i.e., Workbook1:
Accts12-31-07(George); Workbook2: Accts12-31-07(Hanson)).  Is this

I use MS Excel 2007.
I have data validation list for a range of cells. There are 4 values to
choose from.
My requirement: There are 2 values which, when, selected should prompt the

we want to know abou if not function syntax and example.

When I delete a cell from a series e.g. 1 to 10. Then the series gets
disturbed completely. It should automaticaly change.

JUst a bit out of my depth
lets assume we are refering to column D
All cells in row 5 will contain values derived from elsewhere that will be
from zero to around 55000.   ie D5 46560

I find myself asking a lot of questions on these boards lately... Thank you
to all you great people that make the time to help!
I'm trying to multiply values in Columns B and C , like SUMPRODUCT() would
do - the catch is that I only want to multiply pairs where the corresponding

I have this formula
=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)="","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)))
What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers

Can anyone please help me shorten this IF statement:
=IF((C29=S27),S7,IF((C29=R27),R7,IF((C29=Q27),Q7,I
F((C29=P27),P7,IF((C29=O27),O7,IF((C29=N27),N7,IF(
(C29=M27),M7,IF((C29=L27),L7,IF((C29=K27),K7,IF((C

In a cell on Sheet A, I want to display the value of a cell on Sheet B. I
know the column that it is in (R), but not the row - the row should be equal
the last row in that column which has a nonblank value.
In other words, if the first six rows of column R on Sheet B have values,

I would like to save my list as as CSV file, BUT I want quotes and commas.  I
only get commas.  I went to help and was told I can do it in Visual Basics;
however, I do not know how to use the Visual Basic Editor.  Is there
somewhere where I can get exactly what I need?