Not sure if this is possible. Have a main file called Sales, would like to
have a separate file for location 30 that pulls in every row (and it's
respective columns) where the location = 30 from the main file called Sales.
Hi Sue
Why not use a macro to do this ?
http://www.rondebruin.nl/copy5.htm
Or if you want it easy use this add-in
http://www.rondebruin.nl/easyfilter.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Not sure if this is possible. Have a main file called Sales, would like to
> have a separate file for location 30 that pulls in every row (and it's
> respective columns) where the location = 30 from the main file called Sales.