Using filter with VBA (1 Viewer)

[Milton Jacoby]

Hi!

Our company receives lists/worksheets with thousands of rows.

One column,(column B for instance) contains corporate names.

I need to filter column 'B:B' for data that meet 6-7 standard criteria .

My idea is to write (in VBA) a routine to auto-filter column B and somehow mark/update column A with anything, once it displays the filter results.

I cannot figure out how I can (thru VBA) update column A for all those rows that the auto-filter has displayed/selected.

Appreciate any feedback.

MJ

 

[Rich]

Use a query with the criteria you require to filter the records once satisfied with that result, change the query to an update query.

 

[Milton Jacoby]

Rich, Im sorry, I should have noted that my question is for Excel VBA, not Access.

Thanks

MJ