Extract Data onto another sheet based on Criterias

[ameenuksg]

Hi

I have Data on a sheet that looks something like this:

Zip Code/Area Code	Order Numbers
PT	10073301 <tbody> </tbody>
MSW	10073302 <tbody> </tbody>
MSP	10073304 <tbody> </tbody>
WCP	10073305 <tbody> </tbody>
629613 <tbody> </tbody>	10078998
8198341 <tbody> </tbody>	10078989
129811 <tbody> </tbody>	10075643

<tbody>
</tbody>

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.

 

[ameenuksg]

Let's see: What does the following give?

=ROWS(Order)

I found out the cause why the formula counts upto 25 rows only, column B some of the order numbers were on a different format(Text and General) so thats why I think the formula did count beyond 25 rows. Now I have corrected the format to be consistent in the entire column and it works flawlessly.

Thank you so much for your time and kind help ! I really appreciate it.

 

[Aladin Akyurek]

I found out the cause why the formula counts upto 25 rows only, column B some of the order numbers were on a different format(Text and General) so thats why I think the formula did count beyond 25 rows. Now I have corrected the format to be consistent in the entire column and it works flawlessly.

Good work. That's exactly the reason of my inquiry about the number of rows in Order.

Thank you so much for your time and kind help ! I really appreciate it.

Happy to see all is well.