Loacate a range of cells

  • Thread starter Thread starter Donald Johnson
  • Start date Start date
D

Donald Johnson

Excel is Company Forms, that have book numbers in seveval
range of cells. VB6 we enter the book number which has a
var. and a quanity var. So I want to find the book Number
in range B30:B65 and put the quanity in range A30:A65.
This will be on Sheet1.
Any help would be appreciated.
Thanks
Don
 
Maybe =vlookup() against a table that contains the book number in column A and
quantity in column B (probably on a different sheet???)
 
Back
Top