Create an autofilter routine

  • Thread starter Thread starter Jeff Smith
  • Start date Start date
J

Jeff Smith

Hi
I have a spreadsheet where there is a up to 1000 records of data.
At present the product code is manually selected by using autofilter and it
collects all the infomation which is then analysed.

I have to manually progress through the products (which is not a fixed
number and can vary widely depending on production facility) and print out a
report before moving on to the next product.

I was wondering if there is a way for VBA to select the data from the first
unique product code to the last, as a loop. I would then "capture" each
products' data attributes (about 13 pieces of data unique to that product)
and stack them to build up a very useful single page report.

Is this possible and if so is it a big ask for help?

Thnaking you in anticipation,

sincerely

Jeff Smith
 
You might take a look at the Data > Subtotals feature...........

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top