View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Smilingout_loud Smilingout_loud is offline
external usenet poster
 
Posts: 9
Default Help merging worksheets in shared workbook

We are creating a shared workbook to keep track of issues arising within
several projects. Each project will have it's on tab/worksheet within the
workbook. We would like to have a Summary tab/worksheet that will pull
together all of the issues from the other 3 to 4 tabs/worksheets. However, I
can't figure how to do this since in a shared workbook you cannot have a
macro or utilize pivot tables??? Thank You for your help!