How to step among entries of autofilter via VBA code?

[ahenin]

Hi There,

I've faced with a problem while I try to create macro sub:

Once I autofilter the A column and select the...

1.
- first entry - I've got a certain criteria the exact item number - but not as a unique item - and since data may changes weekly
I must only nominate selection as "1st item"

I'd do some function: sum weekly results, and keep only one row with the filtered item (paste special/delete rows)

2.
- 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 me 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 .. ?!

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.