I have a workbook that contains a Template sheet and several copies of it,
N01 - N0X.
I need to control what can be entered in certain cells in N01 - N0X, so need
to use Data > Validation > List.  I also want users to be able to enter

In Excel spreadsheet 2007, I have a column I want to enter figures like these:
5.00
4.90
5.25

How can i extract the hyperlink path from an excel column and get it
pasted into a column in a listbox along with the link title ?
File Page      Size
drawing1        A4

I'm trying to build a macro that runs down my culumn C and inserts 1 blank row each time there is a change in the value from the previous cell.
For example, if I have 100 rows of data and the first five are "CX104" and then the next ten are "CX105", and then the five after that ...

I know I will feel stupid when I hear the answer, but...
If I have a formula (  =average(a1:a5)  ), and I insert a new column, the
formula, being relative, changes to (   =average(a1:a6)   ). This works fine
in a test. BUT I have a working spreadsheet in which inserting a column ...

I have Excel and Outlook 2003. I had a WB that I made some changes to
and then did a File, Send To, Mail Recipient (as Attachment) and filled
everything
out and clicked Send. I did not have Outlook running at the time. The

I have a workbook that was created in Excel 07 but saved as 03. The A column
has text that can be larger than the width but I don't want to format the
width to the text. Column B has the following formula:
=IF(ISNA(VLOOKUP(A5,Inventory!$A$2:$B$3000,2,FALSE)),"",VLOOKUP(A5 ...

i needed a program to set up number combinations and somebody gave me one
my only problem is i dont know how to use it
i cut and pasted it to visual basic and now i dont know what to do

Have created workbook in exel 2002 for a friend that contains some macros.
When came to open in vista 2007 on his pc, it would not run macros owing to
the security level.
Is there a similar low-medium-high under tools as in 2002?  I did go into

I have tried saving an xls sheet under a different name using a password to
stop others from changing the contents but I can't seem to get it to work.
I go to "File", "Save as", and then click on "Tools" on the "Save As"
dialogue box that comes up.

I require that a cell range , say, A1:A23, can only accept, "H","S","Y","N"
or "O" and nothing else.  The file is 52 sheets and will be applied to all
sheets
Can this be achieved by conditional formating or has it got to be

I created an Excel file (XP/XL:2000) which is using the check spelling with
the code :
Range(Cells(19, 2), Cells(50, 9)).CheckSpelling SpellLang:=1033
I would like to know the valid number version for the SpellLang, according

I'm sure this a snap for the sharks...
I wish to create a formula for a basic daily rolling average, up to now I
have been typing in a formula for each day which is  time consuming and very
inefficient,  as follows...

Can you help?
I have a criteria list with numbers in a column:
ID#
12

i want to choose the special data in excel. there always appearing report
mistake and die when using the professional classify.