selecting only certain rows based on other columns' rows!!!

[Nitu]

Hi all,

I am a newbie to vba and macros. I was trying to do this following task for my work. I have a worksheet with 10 to 12 columns. Lets say col A and B has full of values (ex. 150 rows of data). Col E has only few of these rows of data. How can I isolate only those rows from Col E which have values and also get the corresponding values from Col A and B, put all these into another worksheet. Please help me out with this.

Thanks for you help in advance,
Nitu

[arthurbr]

Welcome to the forum.

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

Thanks.

[royUK]

First please read the Forum Rules then edit your thread's title