How copy specific range from one sheet to another using a Macro (V

I

Iván

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Macro for copy with selection.. (please help me) 2
Email a statement 1
Summing occurrences within a list 2
Macro need for Excell 2003 0
Somewhat complex code to copy data from one sheet to another 9
Lookup Table 1
Copy ranges from several sheets to another one in a vertical position 1
Look up values from a table with scales 6

Top