In Sheet1 in column A I have filtered data. Some of the data is visible,
some is hidden.

In Sheet2 in column A I would like to list the data from Sheet1 that is
currently visible. If I change the filter settings on Sheet1, I need the
data displayed on Sheet2 to reflect the change automatically.

I can do this with some Visual Basic, but I cannot use the VB because it has
to function on computers with a variety of security settings.

I suspect that this is a FAQ type question, but I have not run across the
answer.
--
jake