Most valuable professional
  • Hot Topics

Excel Extract Data onto another sheet based on Criterias

Hi I have Data on a sheet that looks something like this: Zip Code/Area Code PT MSW MSP WCP 629613 8198341 129811 I want to extract specific data to be transferred onto another sheet. Is there a formula I can use to transfer order numbers that bear these area codes PT, MSW, MSP & WCP onto another sheet. I have a long list that runs to row 3000 and more to be updated on daily basis. So I would like these numbers that bear the above mentioned area codes on another sheet so that I could separately work on them. I would like that sheet to be updated automatically instead filtering, copying and pasting. Any help would be most appreciated. Thank you in advance.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 9, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel