Marking Filter Rows after Using Advanced FIlter

[GGG]

Hiya

Im a newbie here all. Any help saving my fingers from developing RSI would be appreciated.

My problem is this:

1. After using advanced filter b/w 2 worksheets I have 11000 rows reduced to 6000 rows.

2. I would like to mark each of these rows with a marker such as 'x' for furtehr data analysis down the track. With auto-filter I normally cut&paste to another sheet and then copy the marker all the way down and tehn cut&paste the data back. When I tried this after using advanced filter I found that all the data moved...e.g. inclduing the unwanted data.

3. Is there anyway of marking down each row other than typing an X in a cell beside every row of the filtered remaining data?


Any help is appreciated.

Cheers

Glen

 

[Marty Nix]

Set up a formula in your marker column using the IF function to test for the attributes you want to mark, setting the cell to have the mark if true and nothing if false. Then you won't have to filter for it. It would probably also help to use a filtered DB query to import the data from your two spreadsheets rather than auto-filter/cut&paste ad infinitem.

 

[IML]

Also consider using the "visable cells only" option under edit - goto - special (keyboard short cut control G). For example, You could put an x in one cell and copy it, highlight your filter list, use goto special viasble cells only, and control V to paste. good luck

 

[GGG]

IML you are an absolute gem!

Thanks to all that posted!