skipping blank spaces


B

boosel

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
 
Ad

Advertisements

B

Biff

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

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

Biff
 

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

Top