Displaying results for each filter of a particular column for 5 seconds then onto next etc

[wilson82]

Hi everyone, see attached workbook showing a small sample of records and a pivot-table - note this is just a sample dataset in reality the data is more complex.
What I would like to do is create a macro that will filter thru each "Department" in the data and display the data for 5 seconds then move onto the next subset of the data etc until it reaches the end.

Grateful for any help you can provide, I tried recording the steps but it wouldn't work hence my reaching out on ExcelForum

Thanks in advance.
Karim.

[oeldere]

With a pivot table.

You don't show the expected result, so I guess this is the expected result.

See the attached file.

[wilson82]

Hi Oledare - thanks for the reply and file. Apologies but the expected result is already displayed on the pivot table, what I was after was VBA that would "spool" thru each option in the Description in turn, display for 5 seconds and move onto the next option.
Thanks all for any solutions to this.
Karim

[oeldere]

I can't help you with that.

Just because I am curious, why do you want that?
What is the use for it?

[wilson82]

Ok, appreciate the help above. In terms of the use, note this is dummy data, the idea is to be able to provide this as a summary view for each "description" so their volumes are flashed up on the screen - in reality this will also show data over time and

[wilson82]

Hi everyone - bumping this as currently unresolved. Any help gratefully received - thanks all.
Karim