Conditional row copy in Excel 4

[carrr]

I've been tasked with solving a problem while at the same time having my hands tied as to how I may arrive at the solution (sound familiar?)

The starting point is an Excel sheet (sheet1) containing approx. 3000 rows of data. The desired endpoint is to populate consecutive worksheets with the appropriate rows contigent upon UNIT_NAME (i.e. sheet2 has all rows from sheet1 where UNIT_NAME = "abcdef," sheet3 has all rows from sheet1 where UNIT_NAME = "ghijkl," etc.)

My initial reaction was to let Access do the work and call it into Excel, as Excel is the desired format for distribution, but the fear factor (on the part of the requestor) set in and I was asked to keep it in Excel from start to finish.

I guess what I'm looking for is a conditional copy solution, bearing in mind that the 3000 rows may be fewer or more from week to week.

Thanks in advance for any input/nudges in the right direction...

 

[bluedragon2]

Thanks Ron, I can't imagine multiplying my daughter by 3...



Blue

If I wasn't Blue, I would just be a Dragon...