Autopopulate info from Master to individual WS [Closed]

I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a second worksheet along with some of the columns in the data table. I want the second worksheet to update when the master worksheet updates.
Can someone please help me? I would be extremely thankful for any and all assistance provided.

See more 

1 reply

Registration date
Thursday July 24, 2014
Last seen
August 17, 2019
Thank you
Hello Patti,

Could you please upload a sample of your workbook to a free file sharing site such as Drop Box or and then post the link to your file back here.
Make sure that the sample is an exact replica of your actual workbook and clearly explain inputs and the expected results. If your data is sensitive then please use dummy data.
This will then give us something to work with/test and allow us to better understand your query.

Thank you.