L
Laurie
This is what I'm tring to do, I have a workbook with 2 sheets. The
sheet1 is named data, sheet2 is installist. On the invoice which is
sheet2.
Qt Description BuilderPrice Total
Price
For desc I want a drop down list when product is selected I want the
builderprice to go automaticlly.
In the data Sheet1 I have
Description Price
which starts at A1:A287 same with B1:B287 (lists products/price)
I went to insert/name/define and added database
referes to:=OFFSET(DATA!$a$1,1,0,COUNTA(DATA!$A:$A)-1,COUNTA(DATA!$1:$1))
insert/name/define and added Invoice
referes to: =OFFSET(DATA!$A$1,10,COUNTA(DATA!A:A)-1,1)
then went to sheet2 in the descripton I went to data validation,
list/source and put in =invoice.
I'm getting an error message - the source currently evaluates to an
error.
I can't figure out what I'm doing wrong. Someone please help! thanks
sheet1 is named data, sheet2 is installist. On the invoice which is
sheet2.
Qt Description BuilderPrice Total
Price
For desc I want a drop down list when product is selected I want the
builderprice to go automaticlly.
In the data Sheet1 I have
Description Price
which starts at A1:A287 same with B1:B287 (lists products/price)
I went to insert/name/define and added database
referes to:=OFFSET(DATA!$a$1,1,0,COUNTA(DATA!$A:$A)-1,COUNTA(DATA!$1:$1))
insert/name/define and added Invoice
referes to: =OFFSET(DATA!$A$1,10,COUNTA(DATA!A:A)-1,1)
then went to sheet2 in the descripton I went to data validation,
list/source and put in =invoice.
I'm getting an error message - the source currently evaluates to an
error.
I can't figure out what I'm doing wrong. Someone please help! thanks