Im using the following code to insert a row at a particular point (that
changes), and copy the row above into it. It works OK but for two slight
problems
1) The newly added line remains selected (flashing dotted line around the

How do I format numbers such that they appear like below:
On selecting the "," icon, format the numbers in this way 100 to become
100.00 and if it is negative then (100.00).
Likewise on selecting the "$" icon then display the number in this way 100

How can I stop excel completing text when I enter data e.g. if a line above
says "study day" I enter the line below "student" when I enter "s" it will
automatically enter "study day", how do I stop this?

Is it possible to enter data on one worksheet and for the same data then to
be automatically entered into another worksheet within the same workbook?

Is there any formula that gives you the last number of a column ?
Based on that number can I found the data related to it (from the same
line) ?
My questions are detailed into this Excel file : http://cjoint.com/?ewkEgKqJeI

How do i calculate an expiry date with Date of policy eg: 4 Apr and insurance
period, ie: 60 days, with excel 2000, i am a new user. Thanks in advanced im
stuck.

I have a file that is 17 MB of size. I am finding a problem in saving it. It
alwyas gives the error message that the disk is full. I am using the hard
disk & there is space.
Is it that the file is too big?

I apologize if this is a duplicate. I don't see the original in my sent folder, so nor sure what happened.
I need to modify the following formula so that the final -[E13] is associated only if E13 contains a value. I would greatly appreciate assistance.
Mike K
=CONCATENATE(B13,"-" ...

i cannot find how to enter data in grid form as opposed to row by row . This
is usefull for co ntacts etc.

I have a few spreadsheets which continually link to two other
spreasheets.  I have searched within the spreadsheets but can find no
reference for these links.  When I look in Edit->Links they show up,
but these files no longer exist and are not required.  They even

I have the following formula to generate a full product number
=CONCATENATE(B13,"-",C13,"-",D13,"-",E13)
My dilemma is that I need to modify it so that the final - and E13 will only be associated if E13 contains a value. At least I think that sounds simple, just not sure about the ...

I have two ComboBoxes on a VBA Userform, what I want is for users to
select a major Catagory  from combobox1, which then changes the list
value in ComboBox2. I use named ranges on a hidden worksheet which
contrains lists of constants.  I cannot get combobox 2 to recognise

I have set up a column that will have invoice total.  Then have other columns
that are the "parts" of the total.  IE: total invoice  $100.00 (I type in
this total).  Next columns 3 columns include the parts that equal the total
invoice.  Say like $50, then $30, then $20.  I want ...

This formula is working well:
=LOOKUP((IF(VLOOKUP($A$3,Marks!$B$14:$DO$83,7,FALSE)<>"",(VLOOKUP($A$3,Marks!$B$14:$DO$83,7,FALSE)),"")),{49,"F";50,"E";55,"E+";60,"D";65,"D+";70,"C";75,"C+";80,"B";85,"B+";90,"A";95,"A+"})
This formula is NOT working well. I am not sure if the problem ...

I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO