I have a list of data which is created using various lookup's and if
statements from information entered into 6 cells seperate to the list. Some
cells in the list are not used depening on the information entered, and the
position of the cells that are not used varies. Therefore, I have a list
where blanks can appear in any cell. My list is on the second sheet of my
workbook, and I want the list to appear on the front sheet (below headers
etc,) but without blanks. I actually want the list to appear with a blank
line inbetween each cell of data, but i might be able to add that later.

Does anybody have any idea of how to show a list in another location that
will effectivly update, as the inforation used to write the list is changed.
I have been trying to write a formula that will show a cell if it has text in
it, but that will show the next cell if that cell is blank, and then the next
cell if that cell is blank and so on, but then the next cell has to skip to
the cell following the one that has just been shown?

If more clarification is required please ask.