|This issue relates to a problem I am experiencing in MS Excel 2007.|
I would like to be able to copy multiple rows from multiple worksheets based on a condition.
We have a summary sheet which outlines a set of tasks. then there are 10 additional worjksheets, which breaks down tasks into more descriptive sub-tasks by category.
What I would like to be able to do is to produce a summary of a task on the summary sheet and only those sub-tasks related to it, from one or many worksheets.
The other examples of copying rows based on a condition haven't really worked. thank you.