I want macro which can transfers all row from sheet1 to sheet2 wher
values in column A(sheet1) are equal a or b

--
Alen3
-----------------------------------------------------------------------
Alen32's Profile: http://www.excelforum.com/member.php...fo&userid=3218
View this thread: http://www.excelforum.com/showthread.php?threadid=52425

Without macro...

Apply filter
and in clumn A use custom and select equal a from First combo, option
"And" and equal b in combo 2.

copy the filtered items to sheet2.

If you need a macor record these actions and see the code, which may
need slight modification though.

Thanks a lot

--
Alen3
-----------------------------------------------------------------------
Alen32's Profile: http://www.excelforum.com/member.php...fo&userid=3218
View this thread: http://www.excelforum.com/showthread.php?threadid=52425