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
|