I am trying to import data from one worksheet into another worksheet at a
certain day and time every week. Example worksheet #1 contains real time data
and every Friday at 5 pm I want the data numbers to be transferred to
worksheet #2. Is it possible to set up a formula for that?

I would like to get a VBA code to hide all rows for a given range that
have a value of zero in column z.  Column z has an IF statement
formula.  I would like to have the code activate automatically, so if
the value in column z changes to zero the row would be hidden or vice

I have a worksheet containing a column for phone numbers. However,
some of the numbers are missing area codes and are listed in 7 digit
format(1234567) How do I remove the rows that contain the cells in the
phone number column that only contain 7 numeric characters. And

I have to maintain a timesheet and I need a function to do the math for me.
My spreadsheet looks like this basically:
A                  B                       C                        D        
                E

I am a non-trad and have started a basic statistics class this week (yikes!).
I am looking for an ENGLISH version and description of margin of error.   I
don't understand what those mathematical signs mean or anything.  Can anyone
explain?

Let's say I have cell Sheet1!A1 with the value of BPQ in it.
Let's also say that I have a named range with the name BPQ.
I'd like to reference that named range by referencing Sheet1!A1 somehow and
use it in a SUMPRODUCt statement.   How would I reference the range?

This seem crazy but the size of the validation source field seems very small
and moving around in the formula without it changing seems impossible.  
Normally you can just use the arrow keys but this of course adds or changes
cells.

Does anyone know of a way to increase the size of the fonts of items in a
drop-down list in Excel?  They are appearing very small and unreadable.
Thanks for any response/advice.

What is the best way to add XIRR?  Dowload from Microsoft?  I don't have the
disks w/me.

I keep getting a message saying the above when I try to either hide a column
or change the column size. I still have several columns to the right so I do
not understand this error.

How Can I select a rang and change into a $A$?
Regards,

I typed this in, where the reference A1 was equal to 2.1.  The result should
be 2.25, but for some reason it gives me the " " was a result.  Please let me
know how I can correct my formula to get the correct result.

Basically I opened Excel one day and my tabs to switch through worksheets was
missing. I log information from each month on a different tab and I need to
go back to May but since there is no tab I can't. I went to excel options and
clicked advanced and went down to where you can ...

Hi...I need your help.  
I have a range of cells formatted as date cells that I want to return the
most recent date from the range.  If all the cells in the range are blank I
want to return a blank cell or a text entry like "None".  I found the "MAX"

I know I've gotten this answer before by searching the forum, but I cannot
find it now. I have an array of values
userid value1 value2 value3
u001      58       64      99