Hi All, i have excel data in five differrent workbooks which i will consolidate into one workbook and apply filter and select data by category Xin particular column and if yes need to be moved to another sheet and rename as In active..
Please advise themacro or code to be used to select data by filtering the excel sheet and select only X category in particular specified column. Thanks, Prathima -- ---------------------------------------------------------------------------------- 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