I have several groups that input information into several work books. We have several customers that like to look at the info in the work books. But we would like them to only see what applies to them.
For example in work book one (wb1) company a (Comp A) wants to see sheet 1 in wb2 and wb3 they would like to see sheet 3 in each. Comp B would like to see wb1 sheet 2 and wb3 sheet 4. Could I make a Comp A report work book and a Comp B report work book that contained living copies of the original sheets. So that when we make changes in a work book the report work book reflects the same changes.
Bookmarks