I can send you the spread sheet that I am using. The repro steps are pretty
much straight forward.
1. Have spread sheet data in Tabular format (rows and columns). I have data
of 8 columns and 500 rows. I have columns like the following:
BugID, Bug Title, Bug Type, Priority, Assigned For, Assigned To, Status,
Opened By
2. The possible/current values in each column are:
BugID: any 4 digit numeral
Bug Title: Any text
Bug Type: "60 Day", "Non 60 Day", "Parser Dev"
Priority: "P0", "P1","P2","P3"
Assigned For: "Engineering", "Technical Review"
Assigned To: To whom the bug was assigned to (any alias, initials)
Status: "Closed", "Resolved", blank
Opened By: some name or blank
3. Now have some dummy data in those columns.
4. Sort on the first column (Bug ID).
5. Set "Auto Filter" to all the eight columns.
6. Now chose to filter on "Status" column having value "Closed". Out of 500
rows, some 350 will be selected. The status bar shows "350 of 500 records
found". Make sure that some the first 10 rows of original data are filtered
(do not have "Closed" in "Status" column).
7. Now select first 10 rows (for eg) of first column.
8. Copy and paste in another Excel sheet. You will see all the "Bug ID" s
filtered i.e., not having "Status" column set to "Closed". Basically, I
wanted to see only the first few "Bug ID"s for which the "Status" column does
not have "Closed".
Hope I am making some sense.
SeethaRaman