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
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