Thread: Automatically sort by location --each location having it's own sheet

Hello,

My question is regarding how I can have a master spreadsheet sort out into several other sheets within the workbook based off of location.

The idea is I want to produce bill out information for each location.

Currently I have the list being copied in each location sheet and then I am sorting it within each sheet by location. It's a loasy approach.

I want to have it sort itself by what happens in the master list.

PLease see my attached beta.

Any input would be greatly appreciated.

Thanks