J
Jeff Smith
(This is an updated posting)
I have an analysis spreadsheet that is essentially a database of test
results for various products monitored.
Presently I have an autofilter setup that displays products in a
drop-down filter list. Excel automatically detects and displays a list of
all the unique products in the drop-down list. I do the analyses one at a
time by progressively selecting from the top through to the bottom of the
list. Thanks to Myrna Larson in this newsgroup, I now have copied the list
of unique products to sheet "Data" located at "AE3:AE203".
I want to automate this process so I can click a macro button and let it
perform all of the filtered sorts. I have developed a macro that
captures the (manually selected) analysed results data that drops it
into a summary report.
What I do not know how to do is to use VBA to proceed from the first
product in the list (presumably) using Selection.AutoFilter Field:=3,
Criteria1:="<<variable>>" until the last unique record (bottom of the list)
is found.
This much desired task is beyond my VBA skills and it may be that some kind
person sees this as a straightforward "do until" routine and can offer some
advice, suggestions, guidelines or similar code used for a similar problem
in the past.
Thanks in anticipation.
regards
Jeff Smith
I have an analysis spreadsheet that is essentially a database of test
results for various products monitored.
Presently I have an autofilter setup that displays products in a
drop-down filter list. Excel automatically detects and displays a list of
all the unique products in the drop-down list. I do the analyses one at a
time by progressively selecting from the top through to the bottom of the
list. Thanks to Myrna Larson in this newsgroup, I now have copied the list
of unique products to sheet "Data" located at "AE3:AE203".
I want to automate this process so I can click a macro button and let it
perform all of the filtered sorts. I have developed a macro that
captures the (manually selected) analysed results data that drops it
into a summary report.
What I do not know how to do is to use VBA to proceed from the first
product in the list (presumably) using Selection.AutoFilter Field:=3,
Criteria1:="<<variable>>" until the last unique record (bottom of the list)
is found.
This much desired task is beyond my VBA skills and it may be that some kind
person sees this as a straightforward "do until" routine and can offer some
advice, suggestions, guidelines or similar code used for a similar problem
in the past.
Thanks in anticipation.
regards
Jeff Smith