The sample workbook here, named 'Update Sheets from Master' might help
you get started:

http://www.contextures.com/excelfiles.html#Filter

Steph wrote:
Hi everyone. I have a database-like worksheet with many many columns. One
column (column D) has warehouse location. I would like to take the one
database sheet and parse it into several 1 sheet workbooks - 1 for each
warehouse location. Not knowing too much about sophisticated VB, I assume
I'd do some dort of loop here? Can someone help a beginner in need? Thank
you so much. Bye.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html