Is there a way to have validation for phone numbers, SS #'s.
It would be cool to have a simple validation for number or string with
no other restraints too.
Thanks

if the formula is A1*A2 on the first row
and for each other row i want B2, C2 etc to always be multiplied by A1 how
can i do this. At the moment if i copy the formula from 1 row to the next it
doesnt how the first as the constant.  pls let me know the formula i need to

I accidently reversed the direction of the tab key in Excel. It now goes from
right to left. How do I switch it back?

How do i put formulas in  macro for my workBook cells B6,H6,K6,L6,M6,N6,O6?
I will take the formulas out of the workBook and use a timmer function.
Sub StartTimer()
'

To link data in one workbook to another workbook, must both reside in the
same directory?

I just had a quick programming/general excel question surrounding my
current dilemma. Essentially, I am trying to extract financial tables
from SEC filings (either made in PDF or HTML). Ideally I would like to
have the capability of searching an SEC filing for a specific table

I have a sheet with 10 data columns with titles like product id, product
name, stock, price etc. I have named the range of titels col_titles.
When I try to assign col_titles as the Row source of a list box in a VBA
form, the titles will not show in a list, but appears when I set ...

Hi Folks - I have two worksheets that contain loan numbers. The first
worksheet is for the month of May and the second worksheet is for the month
of June. I need a way to compare the two worksheets in the following manner:
* See if there are any loan numbers in May that are not in ...

Gudday to all XL gurus.
I need some help on using the SORT function.
I have a list of 100 competitors in a scoring spreadsheet that I hav
written.

I opened up 2 version of excel and tried to close one, I forgot the other was
opened and when I chose not to save it I lost my old one also.
If there anyway I can get it back?
I tried system restore but that was turned off also ;(

Is it possible to remove unused columns and rows to tidy things up.
tried to hide all columns I didn't need, but the file size grew t
above 1.5 MB and took a long time to load.
Warre

on my spreadsheet i have several entries from various companies. I am using a
filter to isolate certain companies and their amounts at any given time. How
can I sum total only the amounts selected? thank you

Hi what i want to do is create a spreadsheet that can be adjusted by the
user. For example if we have a user in Illinois who is getting paid 30k I
want the user to choose Illinois from a drop down list and then be able to
enter in thier salary and then for the state of Illinois ...

I have a formula which needs a row reference. The row reference needs to be
the result of search.
The search is on a series of ascending dates in a column.
I need to search the column to find an exact match on a supplied date and

I'm stumped on which formula to use to perform this calculation.
On a sheet labeled Master, there are columns A-P with range of 3:356.
On another sheet labeled Dashboard, I am trying to create a formula which
will accomplish the following: