I need to know how to make an excel worksheet populate a subdocument... for
example if I add an entry to a general worksheet, I want it to automatically
copy to the worksheet for that category - or it would also be ok that if I
did an entry on the category worksheet that it automatically populates (or
copies itself) to the main document. Can anyone help? Can it be done in
Excel, Access, combination? A 3-D reference won't cut it because I need to
utilize many sub documents that compile into a main document automatically.
Client/Boss doesn't want to just filter the lists to obtain data
either...wants separate spreadsheet for each category.

...wants separate spreadsheet for each category

Try this sample construct (from my archives):
http://savefile.com/files/8936561
Auto-Extract_Data_to_Own_Sheet_by_Category.xls

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Trainer needing training" wrote:
I need to know how to make an excel worksheet populate a subdocument... for
example if I add an entry to a general worksheet, I want it to automatically
copy to the worksheet for that category - or it would also be ok that if I
did an entry on the category worksheet that it automatically populates (or
copies itself) to the main document. Can anyone help? Can it be done in
Excel, Access, combination? A 3-D reference won't cut it because I need to
utilize many sub documents that compile into a main document automatically.
Client/Boss doesn't want to just filter the lists to obtain data
either...wants separate spreadsheet for each category.