A few questions:

1) Are you manually entering the data in A1 or selecting a value using data
validation ... or perhaps would you prefer to use a combo box. Is the data
in A1 something which would be the value that would be found and filtered on
in the second worksheet, or just a triggering value?. ... and also, do you
want to copying to occur as soon as cell A1 changes or do you plan to
execute with, say, a button click?

2) Are you copying entire rows of filtered data in Worksheet2, or just
certain columns, where the filter occurs? And where are you copying it to?

It helps to be as clear as possible on requirements, which might explain why
no one has answered yet.

"Syed Haider Ali"
<Syed.Haider.Ali.1so2ad_1122195927.6019@excelfor um-nospam.com wrote in
message news:Syed.Haider.Ali.1so2ad_1122195927.6019@excelf orum-nospam.com...

Dear Freinds.

I have a worksheet having lot of data. I need code for when i put a
particular data in cell "A1" of worksheet1, The filtered data will
automatically be copied in worksheet2.


Thanks

SYED HAIDER ALI


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile:
http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=389679