Copying Select Portions from on WB to another

**DJRockit** · 12-15-2010, 03:10 PM

I have a massive spreadsheet with information occupying columns A thru T and rows 1 thru 465.

I need to copy non-adjacent rows using multiple criteria, e.g. row contains "Frederick" or "Daniel" into a new workbook.

Otherwise, I'll have to do it all manually, which'd take ages.

Thanks for any help,
.DJR

**Mordred** · 12-15-2010, 03:15 PM

Its been my experience thus far that if you want something specific from within a worksheet that you need to code the specifics. Eg:

Cells.Find(what:="Frederick")

Without seeing what you are wanting to do, non-adjacent rows is a little too vague (non-adjacent to what?). Perhaps if you uploaded a mock workbook you will find the help you require.

**DJRockit** · 12-15-2010, 03:38 PM

In this example, I'd want a script that copies the numbers, jobs, and address info for all the painters and carpenters into a new workbook without touching the Boss or manager.

**Mordred** · 12-15-2010, 04:25 PM

I work with 2003 but check this out to see if it is close to what you want. Run the macro called "copyToSheet2". I had to restructure your sheet a little to do what you want it to do but let me know if I am on the right track here.

**DJRockit** · 12-15-2010, 08:45 PM

That works pretty well (thanks!), but ideally the resulting sheet would have only the rows involved in the macro. i.e. The rows with manager and boss will be blank or only the rows I'm interested are transferred.

I am curious about the restructuring of the first two columns. Why was that necessary?

Thanks again!
DJR

**DJRockit** · 12-16-2010, 09:19 AM

Here's a better working example file.

I would like Daniel C's and Mattias A's info transferred to a new sheet without anything else being moved there.

**Mordred** · 12-17-2010, 11:46 AM

Originally Posted by DJRockit

I am curious about the restructuring of the first two columns. Why was that necessary?

DJR

Its just my own habit of having the unique identifiers to compare to in the first column (or row). For me, it makes coding easier to visualize while I'm writing it. I'll look at your workbook throughout today but I have two meetings and a luncheon so I won't be at my desk all day.