Hi
I have workbook consist of 4sheets
I want to Autofilter each cell value in column A from sheet1
and same cell value will get Autofilter in sheet2, sheet3, sheet4 also
i got below mention code on net but it autofilter only particular Criteria
in all sheets
i want to Autofilter each value from sheet1 same will get Autofilter on
sheet2,sheet3 & sheet4
& create newworkbook and paste value in respective sheets of new workbook
for each value in sheet1
i will appreciate any help on this.
Sub FilterAllSheets()
Dim i As Long
i = Application.Calculation
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Dim sht As Worksheet
For Each sht In ThisWorkbook.Sheets
ActiveSheet.Select
sht.Range("A1:A20").AutoFilter Field:=1, Criteria1:="Mahesh"
Next
Application.Calculation = i
End Sub
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
