Would like to limit data entry to 5 columns and automatically position to
first column in the next row to continue entries.

I am trying to figure out if I can have 2 custom buttons.
1 to turn off auto calc.
1 to turn on auto calc
is this possible?

I'm just wondering if a function like =sum(a5:a15) is evaluated at the same
speed as a formula like =a5+a6+a7+a8+a9+a10+a11+a12+a13+a14+a15
I understand that if there is a performance difference it will not be
noticed with only one function or formula, but what happens when in  a

I'm trying to set a column of cell values to be hyperlinks so that when
clicked on a web page will open showing the information for the paricular
order selected from the spreadsheet.
What I have done so far is to insert a column next to the column that has

Using 2003 - I have inherited a workbook that has various command
buttons on the worksheets.  The buttons are attached to a macro.
I need to edit the buttons but I can't seem to get the button into the
edit mode.  How do I do that?

I've been asked to do a survey form for work.  Users would be using a
touch screen laptop to input data with at least one field, postcode/
zipcode requiring data entry from an onscreen keypad.
Is this something that could be created using excel and a VBA form?

Hi, i have 2 list of students names both of which are not up to date
with each other and because of this one list has more students than
the other. I want to search for students names and see if there is a
match, if a match is found i need to copy the email address and paste

I used COUNTIF function to create an attendance-tracking sheet.
I use letter “U” for Unplanned Absence. If I enter U, U, and U, then the
number 3 will appear in the formula cell: = COUNTIF($B10:$AF10,"U").
There is no problem with the formula if the employee takes full day off.  

Is there any way, other than copy & paste, to copy a web page into
excell using a program?
Thank yoy,
Gordon

I'm network techician and can retrieve information like mac-address and IP
from one source, cut and paste to a text file and import to excel. I have
another source to retreive machine names with mac-address, and another source
with mac-address and port number.  I like to  create ...

I want to have different column widths below each other on the same
worksheet, I have tried highlighting the block of columns I want to change &
specifying the different width but it changes all the columns above & below
the columns I want to change. Some of the columns I want to ...

I'm currently stuck in trying to find out to get a max array value
from a variable cell range,
the data is divided in 5 collums, and the variable cell range should
be dependent upon the first column. the maximum value should be

Is it possible for a column to have more than one format, but for those
formats to be similar.
Eg.
I would like to have a multi-format date column. The format can either be

I have a spreadsheet with three columns showing month born, day born
and year born. I want to combine these 3 columns to create a date in a
single column, like 02/14/1942 so that I can accurately calculate a
persons age as of the current day. I would also like to then calculate

Can anyone advise me what the problem is and how to fix it with Excel. What
happens is I might be working on a spreadsheet in Excel and then go to
outlook to send an email and Excel then crashes causing me to lose all my
work. I know one should regularly save one's work, but to ...