Thread: Lookup of Cells and transferring them to make a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Lookup of Cells and transferring them to make a list
Hi Dan,

The easiest way for that is to goto DataAutofilter and filter for 2
on column A then copy and paste the result to your new sheet.

HTH
Martin


Reply With QuoteReply With Quote