I would like to configure a cell to give the data input person the coice of
"Y" or "N".  How do I do this?

I have a workbook that uses this function:
=COUNTIF('unfunded deals'!A:A,">="&TODAY()-30).
My only problem is that I actually need to count by month. How can I
rewrite this so that it will show me, for instance, Month-to-date?

I am importing a report from a phone reporter called ACD.  When the reports
are ran in spreadsheet the time (duration) shows as the following:
303.58841
In order to get the actual time (duration) I have to take the number

I need to bring up a list of folks by clicking only one crew name from a drop
down list... I have the drop down list built and I need to now connect all
the folks associated with the crew I select and bring those folks up on
another list...can anyone help plz

Is there a way I can enter a code in VBA that would protect my sheet if it
had been unprotected for say 5 minutes. Just to make that a bit clearer I
have a worksheet which is protected, I need the user to be able to unprotect
the worksheet by using a button. (that's the easy bit). ...

XP Profesional
How do I ensure that a workbook opens on the same worksheet every time

I am trying to count data in one column based on dates in another,
Column A is either blank or non blanks and column B are Due dates.
I would like to have a count of all non blank cells that have a due
date before and including today.  Preferably using the today()

Excel should allow you to click and hold on a cell that is referenced (click
and hold within the cell that is active) that would create a highlight (in
gray for instance) up to the column letter and left to the row number, to
allow easy visual sighting of the current row and ...

I have a worksheet with data updated from a mainframe database.
Another worksheet has a vlookup-function.
As the imported format is 'General', the lookup-function doesn't work (gives
a #N/A) before I use  *The Copy Blank Fix* that I've learned from

I have multiple worksheets within a single workbook.  
Multiple lines from all worksheets are linked to a single worksheet within
the same workbook.  (Kind of a table of contents.)
I can not get the links to update when I change the original worksheet.

have an excel file i need to save as ascii file and need cell contents of a
particular column to be varying lenghts.

I have header and detail type information, and would like to use the filter
function on the header spreadsheet then have the spreadsheet link to the
detail spreadsheet and just display the rows associated with the data in the
filter from the header.

some cells have numbers  like 345- instead of -345, can someone suggest
a function that changes the minus sign around.
PS some cells have more than 3 numbers. Thanks evereyone.

I am new to this forum. I have a doubt about concatenation. I have two
colums with different keywords. i have to make all the combinations by
using those words. For an example, i have the following words in the
column A.

I would like to update a spreadsheet as follows:
I have a master spreadsheet in which I use different codes to each
record. The second spreadsheet is modified with additional records or
some records deleted. Both spreadsheets have each record with the same