ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autofilter +Create Sheets (https://www.excelbanter.com/excel-programming/403332-autofilter-create-sheets.html)

bpotter

Autofilter +Create Sheets
 
I am wanting to autofilter a certain column, pull out all searsh
criteria and then create sheets built off of this critieria. Then I am
wanting to copy and paste each autofilter to the right sheet.
I have looked through the autofilter loop and found some good ideas
but none of them seam to work for me.
I am really hitting a brick wall on this. Please Help.

Ron de Bruin

Autofilter +Create Sheets
 
hi bpotter

See this page
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"bpotter" wrote in message ...
I am wanting to autofilter a certain column, pull out all searsh
criteria and then create sheets built off of this critieria. Then I am
wanting to copy and paste each autofilter to the right sheet.
I have looked through the autofilter loop and found some good ideas
but none of them seam to work for me.
I am really hitting a brick wall on this. Please Help.



All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com