Thread: Match a cell in a range to a value from another sheet and select r
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johno Johno is offline
external usenet poster
  
Posts: 16
Default Match a cell in a range to a value from another sheet and select r
I have 2 worksheets A & B. I have a variable cell in sheet A which I change
from 1 - 26. I have a permanent range in a column on sheet B of 1 - 26. I
need a macro that will select the row in sheet B that matches the variable in
Sheet A. If I type 5 in Sheet A, the ROW with 5 on sheet B is selected.
Reply With QuoteReply With Quote