Insert and Copy
 

Hi,
I have a material/parts list that begins on row 3, less header and
column names, of the current sheet ("August"). The current sheet aso
has two summation rows at the bottom of it. I would like to
programmitically insert the number of rows that contain material codes
on the current sheet into a new sheet ("September") of the same
workbook and then copy the material codes from the current sheet into
the new sheet. The number of material codes will vary on a monthly
basis, as will the summation rows. I also need to maintain the
formulas in the remaining columns (B:N) of the new sheet. I am using
XL2000 and Windows XP. Can anyone help me? Thanks.