skipping blank spaces

Hello everyone! I am trying to figure out a way to bring data from one spreadsheet while ignoring empty cells, and listing that data onto another sheet. The first sheet with the data has over 700 rows. The sheet I want to bring the data to only has 40 rows. At most the first sheet doesnt use but about 20 rows at a time. But you never know which row will be filled. So I need some way that excel can search the 700 rows and then only copy those cells with data in them to the second sheets rows. Any help would be appreciated. Boosel

You want to "copy" rows of data based on what criteria?

How many columns of data are there that need to be "copied"?

Biff

"boosel" <[email protected]> wrote in
message news:[email protected]...
>
> Hello everyone! I am trying to figure out a way to bring data from one
> spreadsheet while ignoring empty cells, and listing that data onto
> another sheet. The first sheet with the data has over 700 rows. The
> sheet I want to bring the data to only has 40 rows. At most the first
> sheet doesnt use but about 20 rows at a time. But you never know which
> row will be filled. So I need some way that excel can search the 700
> rows and then only copy those cells with data in them to the second
> sheets rows. Any help would be appreciated. Boosel
>
>
> --
> boosel
> ------------------------------------------------------------------------
> boosel's Profile:
> http://www.excelforum.com/member.php...o&userid=34208
> View this thread: http://www.excelforum.com/showthread...hreadid=539696
>