Hi all,
I have a spreadsheet with a large summary sheet that shows information about individuals, this has at the far right end a number of columns that show departments (each department has its own column) in which they will work in the future.
What I would like is to be able to split the summary into the individual departments on their own tabs, but I would like these to remain live, so any update to the summary page will be reflected in the individual department listings.
Hope this makes sense and would welcome any potential solutions.
Thanks
seash
Bookmarks