I am trying to create a MS Excel 5.0 Dialog Control and or form but, after
creating it how do i use it.

I am trying to automatically format a cell to display its contents in either
a date or number format based on which letter is displayed in another cell in
the same row.  I.E.  cell 5a value is M, I need cell 5f to be in MMMYY
format.

I've been struggling with this for a while now trying to figure this out on
my own.  Having found no success I finally broke down and decided to ask for
help.
What I'd like to do is create worksheets that contain lists based on the

what I'm trying to do is copy a cell to a different cell based on date (day),
A1 34   b1 todays date    c1 copys only if todays say = 15th
I thought the formula woul look something like this =if(today()=day(15),a1,"")
but that don't work.

How can I make one cell keep adding once another cell reaches maximum of 8:00.
Im trying to calculate overtime in a seperate column after employees enter
Start/Finish times from drop-down cells.

I have a table of data with a date column and an acreage column.  I want to
count how many parcels of less than 1 acre have sold within the past 6
months.  I set a field with the date from which I want to start counting
(named it DOS1) the used the follow formula: countif(Data!f2 ...

I would appreciate some advise on the following:
1.       I have a workbook with 5 sheets in it. The first four sheets are
named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.
2.       The "Summary" sheet has a drop down box on the sheet with the

I have forgotten the VBA password that I had set for my Excel file. Now I
need to do some urgent code changes and Im unable to do so. I tried many free
VBA password recovery softwares but no luck as the demo versions have their
restrictions. Is there any other way possible ...

I have a column of numbers and want to choose some of them by random. First,
I generate a coulmn of random numbers by RAND function and in next column
select from them by following command:
INDEX($A$1:INDIRECT(C$72),RANK($B1,$B$1:INDIRECT(C$73)))

I want to take inputs from two pages and summarize them on a 3rd page within
the same notebook.  How can I do this?

Hi probably a simple question I am using Vlookup to pull data from one
spreadsheet to another i now need to add a field so it only uses the data if
the dates match.
Any help will be greatlt appreciated

Would anyone know of an easy way to sum a large quantity of unconnected cells
within a worksheet?  The worksheet is on one sheet.  We have it broken down
into many sections within the spreadsheet and each section has a cell that
calculates salestax.  I want to sum all of the ...

excel is having auto recover instead of autosave feature,  and we have to
reset this feature to all the files we make. how can this feature can be used
to use once for all the sheets opened in future to save the data in any type
of lose.

Excel 2003
I think this is easy but I don't know how to do it.  I have a column of
figures that we keep adding to and it gets longer and longer.  I just need a
formula that will return the last figure in the column at any given time.

Hi, I've been using the Networkdays function to work out the date 7 days
previous to today minus working days. I'm doing it in two stages, eg cell A1
= today(), cell A2 = 7, cell A3 = A1-A2, Cell A4 = Networkdays(A3, A1).  
However, it comes back with the answer 6 when I would ...