Choose Data|Filter
Filter on the Col with status with status as closed
Press F5 key, click on Special as select 'Visible Cells' only
Edit|Copy and Paste in the new sheet


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Terri" wrote:

I will try to make this as simple as possible. I have an Excel worksheet for
the year 2008 and among the data, there are closed and finished accounts. If
I want to start a new datasheet for 2009 and only bring over the open
accounts, how do I do that (in baby terms please).
Thanks!