Okay, I know how a normal autofill works.  However, how do I do it in
this case?
Spreadsheet has formulae.  User makes a selection and VLookup instantly
populates the rest of the table with information.  So how do I

Is it possible to type 1210 into a cell and have it formatted with a decimal
automatically placed to make it 12.10. If so is it possible to have it
summed in another cell to  =Sum(A1:A3)  in which you have 1210 entered in
all three cells... the total would be 3630 formatted as 36 ...

How do I remove the ability of a User to Unhide a hidden Sheet?
Thanks

I have two radio (option) buttons (from the forms menu, not controls),
one to protect the sheet and one to unprotect the sheet. These are
linked to cell $D$1  I also have code that protects/unprotects the
sheet in order to sort the data.

I am trying to select only the lowest level cells in a spreadsheet with
grouped columns.
The spreadsheet has cost centres grouped into departments.  The
departments are grouped into divisions.  The cost centres get their

I HAVE A PROJECT WHERE I NEED TO CALCULATE TO FIND OUT IF AN EMPLOYEE IS
ELIGIBLE FOR A 401K ACCORDING TO THE YEARS WORKED AT THE COMPANY. I HAVE PUT
IN THE FORMULA, HIGHLIGHTED THE COLUMNS, BUT WHEN I PRESS ENTER FOR THE
CALCULATIONS TO APPEAR, I ALWAYS GET THIS ANSWER ONLY IN ...

Maybe I was not clear in my previouse posting dated 17/1/07 @ 10:45PM.
What I ment is:
if C1=1 need to go to cell address a8
if c1=2 need to go to cell address a68

I would like to define a named range
such as D5, D6, D7 as the range.
I define it as test1.
And I want to reference it somewhere else.

Can someone explain to me why when the following code executes, the
filename shown in the message box for the first iteration is the last
file name selected in the multiple selection.  The second iteration
show the first file name selected and continues on in order until the

I have one large sheet call a.xls which has data going down the column. e.g
Hr    target
8        10
9        12

Hi, i have posted a few times here and have been helped immensley, but
again i find myself a little stuck on a project.
I am using a userform to input data into the next available row, this
avoids risk to formulas that have been placed onto the worksheet,

Hi to everybody,
In a worksheet I need to move between certain location (cells); these cells
are:
A8, A68, A128, A188, A248, A308, A368, A428, A488, A548, A608, A668

I'm trying to perform this VLookup
=VLOOKUP(A2,[Updated Jan12 Daily D.xls]Daily_D___Bob!$1:$65536,15,
FALSE)
Excel doesn't like the workbook having spaces in the name it keeps

We appear to have hit a barrier on the number of records autofilter will
return.
From a spreadsheet of over 5000 rows, only about 999 can be returned using
autofilter.

I am experimenting with Excel 2007. I normally use Excel 2003. When I have
unusually large amounts of text in a cell *in 2003* the formula bar displays
all of it. Sometimes that takes up most of the window, but the text is about
8 or 9 points. Under 2007, although I can increase ...