I want a macro to repeat every 45 seconds in a shared workbook...the 5 minute
auto refresh just won't cut it as information changes fast than that.

I need to use a cell number in a function that will update itself for each
new row it is in. For example, my function looks like this: VLOOKUP(B3, name,
2, FALSE), where "B3" is the number of the cell I need to use because I'm in
row 3. If I were in row 4 the cell number I would ...

I would appreciate some help in developing two formulas to look up the
maximum value (Stock Market Index) between a range of dates, and show the
date and the matching Index value.
If the dates are in ascending order in Column A, and the indices are in

I have a question about conditional formating.  The way I understand CF is
that I can have 3 conditions and a "default."  I have set mine up like this:
A1  80%
A2  60%

I have two date columns formated like this:
1/22/08 2:19 PM
I need to subract them to get the total time but I need to exclude weekends
and hours not in the normal working day. If the start of the day is 8:30AM

This is a total  from  sheet 1 col how can i paste to a total sheet on
another sheet I tried but just get the fomula under the number.
(e1,e,2,e3,3,4) instead of the sum  
$12,217.94

I have designed a form in excel 2003 that includes several check boxes for
yes and no answers.  I would like to return this form to the originator, but
do not want the the form to be changed once it is returned.  I have tried
protecting the worksheet and check "Edit Object".

I have a user form that takes data entered in cells from sheet 1 and deposits
them in cells on sheet 2 and sheet 3 when the add record button is clicked.
If I hide either sheet 2 or 3 I get an error "Select method of worksheet
class failed"

I would like to have a function that makes a cell say this ...
Reverse Check # (a function that references the check) on (a function that
pulls a date) from account (a funtion that pulls the account number).
All this information that is needed to be referenced to is located in the

Hi, Strange thing has started with Paste Special from one workbook to another
although in the same workbook the function is fine;
When I copy from one workbook, go to the other and select Paste Special the
new window pop up is strange and shows a list to select from as follows;

I think I remember being able to use the mouse as a pen (like in MS Paint) in
past versions of Excel.  When I try to add the ink tools toolbar Excel will
not allow me to use the icons.  I'm thinking this might be just for tablet
PC's.  Does anyone know and/or have any ...

How do I get it so that if I put a - sign it changes to ( ) around the numbers?

using Excel and Outlook 2007.  Trying to import into Outlook set of
names/addresses/phones from Excel.  In Outlook get message to use Excel to
set a "range of data" to import.  Can you tell me how to do that in Excel?  
Thanks in advance!

How would you sort the following matching absolute values to look like it
does in the "After" view?
Before            After   
Record 1    6        Record 9    -2

Hi, I have some confidential info within cells in columns that should not be
viewed by staff. Can you advise the best way I can somehow hide these columns
and not allow staff to simply "Unhide" the columns.  Can I password protect
hidden columns?