Umair.
Bumping your post after 14 minutes is not acceptable.
PM'ing members to look at your posts is not acceptable.
Regards your question - check out either Auto Filter / Advanced Filtering... if you need a Macro use the Recorder to record your Filtering actions.
Bookmarks