i have data saved in Dump sheet of attached excel file. i want only those rows to be visible/filtered whose value for "Agent ID" colum mathces the values that i have stored in IDM sheet. please help me to get this done. i have tried using advance filter but unable to do that. you can download the data file from this link http://www.4shared.com/file/68581255/72e2ac26/Data.html
please help me, thanks in advance.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
please help me, thanks in advance.