Parse database into several files based on column D
 

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.

Parse database into several files based on column D
 

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

Parse database into several files based on column D
 

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.

"Debra Dalgleish" wrote in message
...
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

Parse database into several files based on column D
 

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

"Steph" wrote in message
...
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.