Hi,

Try this

1. Say your data is in range B5:D10 (Sheet1)
2. In B4:D4, type headings - Status, Name and Number
3. In B12, type Status
4. In B13, type New
5. In Sheet2, type Name and number in B4:C4
6. Click on cell B6 of sheet2
7. Go to Data Filter Advanced Filter
8. In Action, select "Copy to another location"
9. In the list box, select B4:D10 of sheet1;
10. In criteria, select b12:B13 of sheet1
11. In the copy to box, select B4:C4 of sheet2
12. Click on Finish

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Eva" wrote in message
...
I have the data in sheet 1 as follows
col A - blank or "new"
col B - name
col c - number

I need to create in sheet2 report that takes only "new" data from column A
col B - name
col c - number

I thought about the offset function - any ideas?

--
Greatly appreciated