Vlookup - Range
 

I have a price list i want to add items to on the second tab of my quotation
spreadsheet. Now when i highlight the 3 coloumns and including the new items
i've added i name it in the top left box like usual but it doesn't save the
new items. so when i go to the quotation template and enter the new part
number the price and description field stay blank.
How do i add items and rename it??

You need to delete the old name first and then re-name.
OR
insertnamedefinemyname
refers to
=offset($a$1,0,0,counta($a:$a),3)
then the range will self adjust based on the items in col a

--
Don Guillett
SalesAid Software

"Mark" wrote in message
...
I have a price list i want to add items to on the second tab of my
quotation
spreadsheet. Now when i highlight the 3 coloumns and including the new
items
i've added i name it in the top left box like usual but it doesn't save
the
new items. so when i go to the quotation template and enter the new part
number the price and description field stay blank.
How do i add items and rename it??