View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ithinkican2 ithinkican2 is offline
external usenet poster
 
Posts: 2
Default AutoFill of Numbers

We are designing a quotation sheet. The data is derived from a table above on
the same worksheet that has three columns: A - Catalog #, B - Manufacturing
Price and C - Install Price.

Example:
A B C
Catalog # Mfg Install
A1 2,390. 1,500.
A2 4,304. 2,600.
B1 2,100. 500.

We will be selecting from the Catalog list (with over 50 items in the list)
and need to essentially, AutoFill in the Mfg and Install prices for the item
into the Quotation Sheet. Problem is, Excel 2007 doesn't allow AutoFill of
numbers.

What formula could we use to accomplish this?