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.