Parse database into several files based on column D

[Steph]

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]

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

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

 

[Steph]

Thanks Debra. That's exactly what I was looking for! But I must say, a
whole lot more complex than I was anticipating!!! Thanks again.

 

[NickHK]

Steph,
If you source WB is structured into tables, you could use a query to pull
out the required data.
Check out the Data > Get External Data > New Database Query menu item.

NickHK