I want to do what seems to me a simple process to autofilter my sheet on a column and the process each filtered row in some manner.
I've tried and tried well over a dozen different ways found on Google and here using AutoFilter but they always result in some error. At this point I can't explain each error as there have been so many different ones. Maybe someone can post a simple general macro to do such.
Here is a basic example of what I'm looking for:
* A sheet with 20 rows and 6 columns of data
* The header row is row 3 (data in rows 4-20)
* I want to filter the sheet on column 1 = 100
* Then I want to process each displayed row using data in the displayed row.
Note: I'll be looping this process through several re-autofilers on column 1. My actually sheets has several thousand rows
Thanks for ANY insights!! as I'm going nuts not being able to get this simple idea to work.
Bill
I've tried and tried well over a dozen different ways found on Google and here using AutoFilter but they always result in some error. At this point I can't explain each error as there have been so many different ones. Maybe someone can post a simple general macro to do such.
Here is a basic example of what I'm looking for:
* A sheet with 20 rows and 6 columns of data
* The header row is row 3 (data in rows 4-20)
* I want to filter the sheet on column 1 = 100
* Then I want to process each displayed row using data in the displayed row.
Note: I'll be looping this process through several re-autofilers on column 1. My actually sheets has several thousand rows
Thanks for ANY insights!! as I'm going nuts not being able to get this simple idea to work.
Bill