I was already doing it thru auto filter & Data>Consolidation some times,but want thru VBA (as I m new to VBA & want to learn as it saves a lot oftime) just to automate the sheet.