I'm not very proficient in Excel, so this may not even be possible....
I do network administration and often find myself having to type in a WEP
key in HEX which, especially on a PDA, can be a time consuming task.
I was looking to have an excel spreadsheet (pocket excel to be ...

I inherited a spreadsheet with computer serial numbers in it. For
various purposes, I'd like to be able to parse these into 3 groups. The
problem is that there are 2 formats, a 10 character format and a 12
character format. Each would be parsed differently. I looked for a

Is there a way to run a Macro depending on the result of a validation
list selection?
I have a list of store names with specific number of techs.
I select Shop A and Macro 1 Runs

I am way over in column EO, reconnoitring data,
when I need assistance of a "what if",
I activate the auto filter, and the active cell jumps back to A1.
any workarounds for this annoying habit?

I have 8 Excel Spreadsheets that gather data from an External Data Source.
I'd like to somehow schedule these files to open, refresh the data, and then
close some stage at night so the data is fresh for when the user gets in.
(it takes about 5 minutes to update each workbook).

I have a workbook with a very detailed worksheet that I want to copy
onto addtional worksheets to run different scenarios.  I can easily
copy the worksheet but it doesn't preserve the detailed page set up for
printing.  How do you get it to copy the page set up too?

Have a cell     A1     drop down list 1,2 & 3
on cell            A2    if 1 then -     if 2 then !     if 3 then x
=IF(A1=3,"X",IF(A1=2,"!",IF(A1=1,"-",IF(A1="",""))))
How do i make the background of cell A2     RED if X     Orange if !  and

How do I automatically insert row numbers in a column?

Using Excel XP.
Earlier in the group someone asked about =SUM colored cells and was referred
to cpearson.com/excel/colors.htm.  I went to the page and found the function
to count the colored cells within a range (which I want to do).  This is the

I need to link two worksheets in seperate files together. The problem is the
tabname on the first worksheet changes everyday. Is there a keyword I can use
to identify the 1st worksheet regardless of its "name"?
Thanks.

after a day of starring at it I'm convinced I need a little help.
I was looking for a way to return the highest value (of Collumn B) to B3
that matches the criteria (name) stated in A3. The database (in another
sheet) consist of 11 different names (in Collumn A) which all have 5

I have written a macro which operates by means of ctrl + Q. (This letter was
merely an arbitrary choice!)
The action is as follows:-
1. Enter new data in a cell then press <ENTER>

is it possible to customise the right click menu, ie add or move items?
Darren

When I have outlook open and I then try and open a excel file it opens in a
mail format and try as I have I can't find the setting to stop it from doing
so. Please help because it is really frustrating and laborious having to
close outlook just to open a excel file normally.

I have some code, whereby I am trying to lock a cell. I keep getting
the message:
Runtime error '1004':
Unable to set the Locked property of the Range class.