Autofilter help

  • Thread starter Thread starter ChrisBat
  • Start date Start date
C

ChrisBat

I am trying to build part of a macro that will filter on a list based on
two criteria, and then change the data in Column A based on the data
that is pulled.
A couple of problems:
(1) The number of items in the list changes everyday, and so using
static references won't work
(2) I need to go through a couple of dozen criteria in both columns,
and so I'm thinking a Loop would work best. However, having only
limited knowledge of VBA, Looping is not something I'm familiar with.

Here's part of the code that I've got so far:

Dim Status as String
 
The part sure is correct.

if you have headers for your autofilter as shown and add 3 the autofilter
will pick it up. Try it.
a
1
2
 
My thanks, but I seem to have written something wrong on my original
post - I don't want to add to the list, I want to overwrite the data in
column a based on what the filter pulls up on the two criteria.
sorry for the confusion.......
chrisbat
 
Hi Don,

I put three periods going down to indicate that there was more code
between the Dim statement and the Autofilter portion of the macro.
Sorry for the confusion, didn't want to jumble my post up with a tonne
of unneeded lines.
Thanks,
Chris
 
After these two lines, I see nothing else????
=========
Here's part of the code that I've got so far:
Dim Status as String
========
 
Here is everything in your post:

-----------------
Hi Don,

Here's the code that I've got:

DIM STATUS AS STRING
 
Back
Top