Can this be done?

[aurbo]

I would like to do the following if possible;

Worksheet 1 contains data I would like to send to worksheet 2 using a buton or macro on sheet 1.

Here is a detailed explaination of what I need to do.

worksheet 1, select a column, filter the column by non-blanks.

copy the first 3 cells in that column to worksheet 2. then copy the filter populated rows row by row to sheet 2 until the next row is blank indicating all rows have been copied

each column filtered will not always have the same results which is why the check for a blank row is needed.

 

[Jim North]

Yes, this is possible to do several ways. How your Excel skills... and VBA?

 

[Troy]

I would think most of these actions can be recorded. I would try that first and see how much can be recorded. Just open sheet and Tool-Macro_Record New.

 

[texasalynn]

I had something similar to this and got some very good help from Jay Petrulis. (I can't take the credit - he did the work). Take a look at this and see if that gives you what you need. If not post back


http://www.mrexcel.com/board/viewtopic.php?topic=15938&forum=2

HTH
texasalynn