Loop thru Drop Down (created by validation) and put filtered choices in worksheets

[MikeL]

Hi,
I would like to loop thru all items in a drop down on Sheet1 and copy/paste results to different worksheets in workbook

Similar to how Show Report Filter Pages in a Pivot table works.

Thanks in advance.

 

[My Aswer Is This]

We would need specific details.

1. On what sheet and where on the sheet is this drop down
2. Copy each cell in the drop down and paste them where.

We need sheet names and ranges.

Like Sheet("David") Range("B6")