Try this sample from my archives*:
http://savefile.com/files/351776
AutoCopy Lines by Code col in New Sht.xls
*link in sign-off below
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michelle" wrote:
I have a usage report I create on a daily basis, the information on it
changes daily. I would like to take specific items, by the row, to create a
new spreadsheet. Can this be done?
Michelle
Bakersfield, CA