Range Formulas
E1:E1005 =COUNTIF($D:$D,"<"&D1)+COUNTIF($D$1:$D$1,D1)+0
F1:F1005 =INDEX(D:D,MATCH(ROW(),E:E,FALSE))
G2:G1005 =IF(COUNTIF(H$1:H2,H2)=1,MAX(G$1:G1)+1,"")
H2:H1005 =IF(F1<>9999,(VLOOKUP(F1,TRANX,9)),"")
I2:I1005 =IF(MAX(StockCount)<ROW(1:2),"",VLOOKUP(ROW(1:1),StockList,2))
J1:J1005 =INDEX(I:I,MATCH(ROW(),K:K,FALSE))
K2:K1005 =COUNTIF($I:$I,"<"&I2)+COUNTIF(I$1:$I2,I2)
StockCount =OFFSET(Sheet1!$G$1,0,0,COUNTA(Sheet1!$G:$G),1)
StockList=OFFSET(Sheet1!$G$2,0,0,COUNTA(Sheet1!$G:$G),2)

I adapted the above formulas from sample sheets by MS and others as
well as the solutions in this NG. My objective is to autoextract data that
meet certain criteria from a Transactions sheet and auto post the selected
transactions to individual stock records using HLOOKUP. For this the stock
names have to be listed anywhere in ascending order beginning from a
fixed cell (maybe J2). Presently the stock names appear from JXX to J1005
(possibly because of " " records (ie transactions that do not meet the
criteria)
also in ascending order. I desire the start cell to be fixed rather than the
the end. Thanks in advance for those who want to try. I am avoiding any
any macro as I want the wholework book to be dynamic. I will definately
acknowledge those who try.
RobertR