View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dubbakor@gmail.com is offline
external usenet poster
 
Posts: 5
Default Selective rows from one sheet to another

On Dec 6, 11:31 am, wrote:
Hello All, I have two sheets - Sheet1 with a single ColumnA of 150
rows carrying random numbers and another sheet Sheet2 with 1000 rows
and multiple columns. Values in ColumnA on both sheets are same
(Sheet1 is a partial list carrying only few rows of Sheet2). I would
like to filter the rows in Sheet2 so that only rows of ColumnA value
from Sheet1 is seen on Sheet2.


Sorry, clicked the send button bit too soon

If you can please share your thoughts as how this can be achieved,
would really appreciate it.

Thanks !
DK