Hi,

Sure- mail away.



CHORDially,
Art Farrell

"Santed593" wrote
in message ...

Hi Art,

Thank you for your response. I tried the code but it is not working.
What I am trying to do is, if I enter the AcctNo. (5685) iit will
filter the data for that AcctNo. That means it will list down all the
rows with promo titles (Column A) and corresponding goals for that
account to a new worksheet. I am trying to attach an excel spreadsheet
but it will not allow me. Is it possible to email this to you so can
see the sample spreadsheet?


--
Santed593
------------------------------------------------------------------------
Santed593's Profile:
http://www.excelforum.com/member.php...o&userid=25108
View this thread: http://www.excelforum.com/showthread...hreadid=394362