View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave91 dave91 is offline
external usenet poster
 
Posts: 3
Default search column for specific cell using vba

as a novice I need help trying to set up a billing system for my club
although I have done this using VLOOKUP, I would prefer to set it up in
programming with vba.
0n sheet 2, I wish to search down column A1 for a number equivalent to a
number in a particular cell in sheet 1, then select and ofset to adjacent
cell in column B to copy the value and paste to anther cell on sheet 1
any help would be appreciated