View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zerbie45@gmail.com is offline
external usenet poster
 
Posts: 1
Default consolidating values from single worksheets - how to ?

hi guys,

I have an excel spreadsheet that contains multiple worksheets.
each worksheet has a task list (say task ID and task Description).
I would like to have the tasks reported in each worksheet to be also
shown (automatically copied) on a separate worksheet so that it will
include all the tasks shown on the single worksheets.
is this possible ? how should I do this ?

thanks
zz