I'm trying to create a form that allows users to enter goals for the
year (the word part) and then enter weights and scores for those goals
that will be calculated (the excel part).
I've been doing some research on trying to do this and I've reached a

I would like a macro that will rename a sheet to today's date.  I already
have the date set in A1 as val(today()) so that it doesn't change once the
sheet is copied and viewed another day. Now I would like the macro to name
the sheet as the date.  Since the program enters the ...

I want to calculate the total number of weeks in a month.
Please help.
Thanks,
Navin

I have a row of numbers that range from 0 to 100.  I want to find the minimum number that is also greater than 10, sort of like
=min(A1:A50,">10") which I know will not work.  Any help?  Thanks in advance.  

Have the following in a sheet code that i would like to activate when
the enter key is pressed in B5.
tried the following, but no success, the 1st part i was hoping would be
the change event that would run a sorting macro in the 2nd part.  any

I want to write a macro that selects a range that starts in A3 and ends in
Jsomewhere. Is it possible to refer to an unknown cell in an known column?

Is there a formula that will count the number of characters, and spaces
between characters, in a short paragraph created by a string text?  It
is acceptible if spaces cannot be counted.  Thanks.
Michael

Hello all...
Is it possible to tell excel to save my worksheet automatically. either
daily at a specific time or hourly or anything like that? My work network is
incredibly unstable and tends to go down often. It gets very difficult to

When I click on an excel file , only the program opens with a blank page. I
can only open file by opening the program and clicking File Open
Any idea why this happens ?
Thanks

Hi Dave,
I came across your worksheet data entry form, adapted the idea for my
project and it worked perfectly fine.
Right now, i received a feedback from my team asking whether an edit

I have been struggling through a problem from long time. Can we insert
Custom Properties in the header in Excel. If yes, how??? Is it possible
only through macros & not without that?? Can anybody get me the macro
code.

I got help with this before Christmas
With ActiveWorkbook
  .SaveAs Filename:="" _
           & .Worksheets("sheet1").Range("A3").Value _

Can anyone tell me how to program a cell so that it locks automatically
when another cell is filled. For example I have a row with 5 cells,
A1,A2,A3,A4,A5.  As soon as I enter anything in A1 I want cells A2,A3,A4
and A5 to lock and remain locked until the manager comes and enters ...

I need help constructing a formula to map a range of numbers to a
corresponding range of letters like below.
Each number is a unqie cell, and each letter is in a unique cell.
INPUTS

I'm working on a spreadsheet of soccer fixtures and results for a school
project.
I've done formulas to result in games won, games played, points etc.
What I'm having problem with is the draw scores.