I have a worksheet with dates across the top with information relevent to
that date beneath. What I wish to do is transfer the information for todays
date only to another sheet that will update itself as the date changes.Can
anyone help.

I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
Actual(V5) columns. This is repeated 12 times across the sheet. I then
have "Buget Average" and an "Actual Average" cell. The budget average
is easy because all cells have values for all 12 months. How do I

I would like to make a macro that creates a dialog box with information from
the worksheet.  
I have a membership database and I would like to have the dialog box show a
summary of how many female members, male members, the breakdown of different

Chop off parts of the statement
Hi.
I would like to do the following:
1) Chop the right part

I have the following formula, which returns an unexpected answer
=IF(AND(G11="Off",G14>0),"Not Expected
In"),IF(OR(F13="",F14=""),"",IF(AND(G12>0,G14<=0),"No
Show",IF(ISERROR(IF((F13-F$7)>F11,"In Late","")),"",IF((F13-F$7)>F11,"In

I would like to extract the fraction part out of a number. For example:
1.5 -> 0.5
23.45 -> 0.45
25 -> 0

Hey I am currently working on something, take a look
I want it to be like this: If B3=nosum then A3 is not included in the
sum at the bottom, take a look at the picture
Thanks guys!

Good day everyone ,
I hope someone can assist me
I am trying to figure out how to ie:
take 2 spreadsheets,

Have a spreadsheet with 12 tabs.
Each tab has 12 line charts based on a specific group.
Each line in the chart represents one year (2000 -
2003)  Data points are the months.  We've

I am trying to set up a worksheet for work.  I would like to have some
conditional formatting.  In the date worked column will be dates going back
months if not years.  I would like to set up color changes for dates that are
90, 120, 150 days older then the date at the time of ...

I have a workbook that uses VLOOKUP on the Summary sheet to find values
associated with a Name and Week #.  The worksheet I'm trying to capture the
data from looks like:
  B           C            D             E

I am trying to write a formula that inputs the value of a cell that is in
another sheet.  ex.  =sheet1!A:7   How can I write it so it gets the value
from the last entry in the column without me specifying which cell it is.  
ex.  =sheet1!A:(the last cell in the column that has a ...

I'm trying to set up a 6 column dynamic named range where all of the
columns could possibly have text or number (ie Number Format = General)
as well as any number of blanks.
To locate the bottom-most row with data I have adapted a formula from

How do I change Hrs and mins in a cell in one work sheet to autoformat into
minutes in a cell in another worksheet?

Excel 2003
How do I add items to the context menu that appears when I right click.  I
would like to add items that will run a vba function just as I can with
keystrokes using the Application.Onkey function.