One guess ..

Assume the 6 source cells are A1:F1 in Sheet1

In Sheet2,

Put in A1:
=IF(Sheet1!A1="","",COLUMN())

Put in A2:
=IF(COLUMN()COUNT(1:1),"",INDEX(Sheet1!$A$1:$F$1, SMALL(1:1,COLUMN())))
Select A1:A2, copy across to F2. Hide away row1. A2:F2 will return the
required results from Sheet1's A1:F1, all neatly bunched to the left. Test it
out ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GARDNERGUY" wrote:
I have 6 cells, I'll call them A-F, that may or may not have data in them.
I want 6 other cells to check the first 6 for data.
If A is blank, check B and insert if not blank.
Then check C, if blank, check D and insert.
Any of the 6 could be listed in any of the other 6 cells.
If only C has data, then only one cell on the new page is necessary.
I A,C,E,&F have data, then 4 cells on the new page are necessary.
I want this to be automatic as data is entered in the first 6.

Hope this makes sense. Thanks for the help.