Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidating values from single worksheets - how to ?
Are the tasks and description in column A and B. Does each worksheet have
aditional columns? Are the columns the same in each worksheet? It help to have examples of the data to get the macro correct the 1st time. " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating and totaling rows into single row | Excel Discussion (Misc queries) | |||
consolidating data in a row based on a single identifier | Excel Discussion (Misc queries) | |||
Consolidating Macros Into Single Workbook | Excel Discussion (Misc queries) | |||
Search multiple values & return single value - seperate worksheets | Excel Worksheet Functions | |||
How to sum the values of a single cell from multiple worksheets | Excel Worksheet Functions |