Hi,

Slight additions to previous answer:
The answer presupposes that your data has a column that indicates that an
account is opened or closed:

1, Select the range where your data is including the titles
2. Choose the command Data, Filter, Auto Filter (slight correction from
previous post)
3. You will see drop down arrows at the top of each of the selected
columns, on your title row.
4. Open the one over the column that contains information which indicates
whether the account is open or closed. Pick the "open" choice from this list
- I don't know what that is since you didn't show us a sample of the data.
5. Select all the cell you can see and choose Copy.
6. Move to the new sheet and choose Paste

Note you do not need to use the command Edit, Go To, Special, Visible Cells
only.

I hope this has been in "baby steps" since that's what you asked for.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"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!