How to step among entries of autofilter via VBA code?

Dear All,

I've faced with a problem while I try to create a sub - autofilter A column and select the...

- first entry (but not as a unique item, as data may changes weekly)
once 1st item filtered - I'd do some function: sum weekly results, and keep only one row with the filtered item (paste special/delete rows)

- than step on next entry and do the same as before

- take these steps till the end of autofilter list, than remove autofilter.

.. with this action, I'd get the sum value of my weekly forcast on each incividual items.

Would you pls. help to solve this problem, as I've no clue how should I do it.. : (

Thanks a lot in advance!
Adam

ps:

I've started as:

ActiveSheet.Range("$A$2:$BN$400").AutoFilter Field:=1, Criteria1:= _
"17963-E050LF"

but critera shoul be like .. 1st entry ... 2nd entry ... last entry .. session end .. ?!

Thanks Cytop, I'll try!

Hi ahenin

Pictures are of little value.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

Hi ahenin

This Code is in the attached and appears to do as you require...CTRL + z will fire the Code

Please Login or Register  to view this content.

Hi ahenin

The structure of your Workbooks are different. Code is based on that Structure.

I'll get back to you tomorrow. In the meantime...notice the difference?

Hi ahenin

If the solution you described in your PM works for you go with it.

Regarding this

the code you made do not count after the 20th row

I simply got lazy...the Code in the attached remedies this.

Regarding this

I just left sheet 'raw data' as a reference, but now seems both sheet must be the same?!

You can run the Code on either Worksheet as long as the Structures are the same...merely change this line of Code

Please Login or Register  to view this content.

Here's the revised Code

Please Login or Register  to view this content.

You're welcome...glad I could help. Thanks for the Rep.

Hi Adam

Here is the Commented Code...anything you don't quite understand...let me know.

Please Login or Register  to view this content.