Is lookup the best function to use?

[Erik]

Here is what I'd like to do:

a b c d e
1 # # #
2
3 # # #
4# #

I would like to take the information above from sheet 1 and have it automaticaly transfer over to sheet two in the specified cells as shown below:

A B C D E
1 # # #
2 # # #
3 # # #
4

Is there a formula I can use to automaticly transfer and sort the data from sheet 1 if there is data in a cell and put it into sheet 2 all nicely sorted and organized?

Thanks,

Erik

 

[Vasant Nanavati]

Your example is confusing. Where is the data in row 2 of sheet 2 coming
from? Row 2 on sheet 1 seems to be empty.

--

Vasant

Here is what I'd like to do:

a b c d e
1 # # #
2
3 # # #
4# #

I would like to take the information above from sheet 1 and have it

automaticaly transfer over to sheet two in the specified cells as shown
below:

A B C D E
1 # # #
2 # # #
3 # # #
4

Is there a formula I can use to automaticly transfer and sort the data

from sheet 1 if there is data in a cell and put it into sheet 2 all nicely
sorted and organized?

 

[Erik]

The Data from Row 2 on sheet two is coming from row three on sheet one. This might be a simpler example:

Sheet one:
A B
1 # #
2
3 # #

Sheet 2

A B
1 # #
2 # #
3

The data in A1:B1 on sheet one is transfered to A1:B1 on sheet two (remains the same)
But the data from A3:B3 from sheet one is transfered to A2:B2 on sheet two. I would like to keep the data in their respective columns, but if there are empty rows on sheet one I would like the data to 'move up' on sheet two. The reason I would like to do this is to make the data collected in my spreadsheet printable.
I currently am using over 5,000 rows but only about 150 of them contain data, the rest of the rows are empty but they may be filled in in the future. They are basicly their "just in case" I input more data.

Thanks for your help,

Erik