View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Iván[_2_] Iván[_2_] is offline
external usenet poster
 
Posts: 7
Default A Macro for copy with selection.. (please help me)

Friends, how I can copy specific a specific row range in other sheets with
conditions special. ie:
copy from:
Sheet1: A B C D
1 W 100 200 300
2 400 500 600
3 700 800 900
4 W 1000 1100 1200
5 1300 1400 1500
.... (I not know how many rows there)

to Sheet2 (ONLY range Ax to Dx when Ax = "W")
A B C D
1 W 100 200 300
2 W 1000 1100 1200
....
Thanks, Iván