View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deb Deb is offline
external usenet poster
 
Posts: 102
Default Multiple tables with lists to one table.

I have a different worksheet for each department.
They are listing things to accomplish by 6 month, 5 month, 4 month, 3 month,
etc.
I want to combine all departments on one sheet keeping it in the 6 month, 5
month, 4 month, 3 month, etc. groupings.
Then when they add an item on their individual worksheet, and in a specific
group, I want that information automatically added to the combined worksheet.