Hi Experts,
Basically i have 4 different workbooks data with same format i will consolidate all the 4 work books and apply filter and go to Column AH, and filter by X category and move them to new sheet and rename that new sheet as In active like wise ill perform the same for these four columns as well AI, BE ,BG, BZ is there any possibility to automate this thing please advice i am end user in excel macros. Thanks, Sekhar -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel