Copy Row and row above to new sheet

[Guest]

Hi,
I have a sheet with subtotals sample data:
PART CPART JAN FEB MAR etc TOTAL
XYZ XYZ-1 500 1500 500
XYZ XYZ-1 100 2000 1000
600 3500 1500 5600 (This is subtotal row)
XYZZ XYZ-15 2000 1000 500
XYZZ XYZ-15 500 1000 1000
2500 2000 1500 6000 (This is subtotal row)
The end product I would like to get is:
PART CPART JAN FEB MAR etc TOTAL
XYZ XYZ-1 600 3500 1500 5600
XYZZ XYZ-15 2500 2000 1500 6000

Basically, need one row that shows the part,cpart,subtotals. Right now
Manually I would have to copy The Part,CPART then The subtotals, which if I
have alot of parts would be to time consuming.

So thinking need a few steps:
1. If Column A empty then copy as values that row and row above to new sheet.
2. In new sheet if Column A empty then move that row Up.

I hope I'm explaining this correctly. I know that I can delete a row if
column a is empty but need to figure out how to copy that row and row above
to new sheet.

Please advise any help. Really appreciate it
Juan

 

[Dave Peterson]

I'd remove the subtotals and then let excel put them in:

Data|subtotals (maybe twice???)

Then use the outlining symbols to hide the details.

===
It sounds like a perfect excuse to learn about pivottables (data|pivotable).

To read more about the pivottable stuff, you may want to look at some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx