How to moving cursor when data are filtered

J

jwan

Hi,

I had read so many articles about moving rows up and down using offse
in macro... however, it doesn't work when the column is filtered.

Sample Data:

Row
1 Fish
2 Meat
3 Vegie
4 Fish
5 Fish

if I filter the row to show FISH only the results would be:

Row
1 Fish
4 Fish
5 Fish

My question is, how to move the cursor up and down when data i
filtered (of which filtered data can be anything aside from fish)

Jojo W
 
J

jwan

Actually, I'm making up a script that would automate the creation f
statement of account in a separate sheet. The problem is that the mai
worksheet contains all the data from all customer sales and whateve
customer or item being filtered will be the only data that will b
copied into the statement of account.

In my script, what I intend to do is to copy from the first most dat
from the data worksheet to the statement sheet. One by one goin
downward until it reaches the last row.

Another way is to do a compare for each row, but the data are too man
and it takes quite a while to finish a simple process. And if it
already filtered, out of 10,000 rows, many only around 10 are needed.

Jojo W
 
Top