Thanks for any help in advance. It is greatly appreciated.

I'm trying to write a macro that will look at my master data sheet (say it's named Schedule) and then find all the rows that are from a certain location say (BTYNOPS) and then paste it into another sheet that is named (BTYNOPS). There are like 25 different locations that I need this macro to look for and paste into the appropriate sheet. I can post an example spreadsheet if that would be helpful.