ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need Macro! (https://www.excelbanter.com/excel-programming/356477-need-macro.html)

Alen32[_10_]

Need Macro!
 

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


Abdul[_2_]

Need Macro!
 
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.


Alen32[_11_]

Need Macro!
 

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



All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com