View Single Post
  #1   Report Post  
Tally38 Tally38 is offline
Junior Member
 
Posts: 3
Default Sharing infor between worksheets based on terms

Hello,
I have a master pipeline and in the Status column there will be terms such as "closed", "approved", "pending", etc. I also have additional worksheets in the same workbook titled "closed", "approved", "pending", etc. I want to be able to look at the master pipeline and see everything that was input and have the "closed" rows copied to the "closed" worksheet, the "approved" copied to the "approved" worksheet, etc. How can I do that?