Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge two files based on one column | Excel Discussion (Misc queries) | |||
Parse cell value based on contents | Excel Discussion (Misc queries) | |||
csv files do not parse and open up like they should | Excel Discussion (Misc queries) | |||
How do I parse one column into different columns? | Excel Discussion (Misc queries) | |||
Parse csv files | Excel Discussion (Misc queries) |