Creating other Sheets from a Master Sheet

Hi, I am new to this forum, and this is my first post. However, I've used this forum many times to solve problems in Excel by searching past posts, so thank you everyone for all your help (even if you didn't know it!)

I am preparing a budget that lists over 300 parts. The parts are used by 7 different sites (cities) throughout the U.S. I am trying to use a master list of the parts to populate individual sheets of the sites with only the parts that they use.

After searching for a similar problem on this forum, I tried using the macro in the following post and adapting it to my needs, but I wasn't able to do so:

http://www.excelforum.com/excel-prog...-workbook.html

I appreciate any help. My file is attached. Budget.xlsm

Based on column A

AB33, Thanks for your response. However, I am trying to create sheets based on the cites (columns E-K), not the parts as you did in the file attached.

So ideally, the macro creates only 7 sheets (1 for each city) with the parts used by that city in the sheet. I hope this isn't confusing. Thanks for the help!

I do not know how the output looks, so please attach a sample desired output with the attached above.

I've attached the desired output. As you can see, the 7 city sheets are the output from the master sheet, "Parts." Once again, thanks for your help!

Budget Example 2.xlsm