View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default copy a formula down the colum and advance it by row only

Add $ to the column

You can either do A1 $A1 A$1 $A$1

the dollars sign are uused for copying cells to indicate you don't want the
column or row incrtemented when you do a copy

"ShoDan" wrote:

PRODUCT DESCRIPTION
3X5 RAS PAD 18X5 RAS PAD 18X18 RAS PAD RAS SOCK E/C CHARGE DELIVERY
P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE P.O. PRICE
$2.70 $2.00 $1.00 $1.00 3% OF PROD. $20.00
QTY DELV QTY DELV QTY DELV QTY DELV QTY DELV QTY DELV
43 16 2 $4.50
27 11 1 3 $2.97
54 15 $5.27