Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbers won't autofill | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
Autofill | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |