One formula, many possible answers.
 

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.

One formula, many possible answers.
 

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.