Require ability to copy multiple rows

November 17, 2011 at 02:19:17
Specs: Windows XP, Xeon
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.

See More: Require ability to copy multiple rows

Report •

November 17, 2011 at 13:06:24
I would consider using a filter instead of copying rows. You are going to need some VBA code if you want to actually copy the rows and that's going to be complicated and something that will need to be maintained.

Using an Advanced Filter might work out better.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question