I have a weekly project report in Excell that needs to be filled out on a
weekly basis till the end of the year.  Each sheet is the same and I only
want the user to be able to fill in the exact same cells each week and lock
down the rest of the sheet to protect the formulas.  Is ...

I have a requirement to dynamically build/create a hyperlink in a workbook
which would allow the user to quickly move between worksheets. ALL
informataion is contained within the workbook so there is no need (or
desire) to have any external links. The workbook would be laid out ...

I want to refresh my data every day at 12am. Does something like this
make sence?
Public RunWhen As Double
Sub StartTimer()

I'm building a sheet in where I want to store data about some web-sites
we surf in the net and could be interest for my company. So I insert a
serie of characteristic of the web-site in the colums (usability,
navigability, etc.) and in the rows an evaluation of every

Is there a NVL type function for excel?
What I am trying to accomplish is a fomula that will give an IRR value
if exists, but if IRR produces an #DIV/0!, return "N/A".
Right now I have the formula ...

   A      B    
  $10  
  $20   $20
How do I get a count of the cells in column B only for the nonblank cells?  

For example, I need Excel to take the last day of a quarter (6/30) and add 10
working days resulting in the date of the 10th working day.

I have data in several columns, the first being a date and timestamp
and the second being an identifier (numeric).  The numeric identifier
occurs repeatedly at different times (each identifier appears in
numerous rows).

I have 30 securities with 5 years on monthly returns
Securities across row A and returns down the columns
A   B      C        D
1  IBM  TGT   HD

Have quite a range for sorting. Using columns A-BY and 336 rows. Columns A-Z
are filled with phone, name, address prices across. AA-BY,continuing across,
a portion of the original address is used, city, state, x the city column and
how many times.  Keep having a problem after ...

i am having a problem where validation seems to disappear after i add data to
a list.  i created a list of data and defined a name.  i included extra rows
in my column list cause i know i need to add data regularly.  i added data to
my list, and as soon as i go to the dropdown, it ...

=IF(MONTH(TODAY())>MONTH(E21),YEAR(TODAY())-YEAR(A1),
IF(AND(MONTH(TODAY())=MONTH(E21),DAY(TODAY())>=DAY(E21)),
YEAR(TODAY())-YEAR(E21),(YEAR(TODAY())-YEAR(E21))-1))
The formula above works out the age of a person once i put their birth date

I am trying to get a formula function to work where I want the forumla to
check one column and find all of the alike numbers and then add up another
column while all of the numbers in the column are correct.  Here is an example
I am importing an CSV file and it has over 800 lines ...

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Since my table is subject to constant change, I would like to know how to create
a variable col_index_num which will look up the right column itself, eg look for
the column heading which contains the word "list" & return ...

I have the task of Copying information from a website into an excel
spreadsheet.
The information is listed like this on the website:
*Company Name*