software

I have a table 10 columns wide, 15 rows high with data in quot;SOMEquot; of the
cells
My problem is that I want to build a list from this table reading from
top to bottom. The list can have no blank cells. I can't find a way to
do this because some of the cells are blank. Any help would be greatly
appreciated--
auspcs
------------------------------------------------------------------------
auspcs's Profile: www.excelforum.com/member.php...oamp;userid=34575
View this thread: www.excelforum.com/showthread...hreadid=543444
You could try a macro like...Sub CreateList()
For Each Cell in Cells(1,1).CurrentRegion
If Cell lt;gt; quot;quot; then Cells(65536,12).end(xlup).offset(1,0) =Cell
Next Cell
End Sub--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=543444
You could try a macro like...Sub CreateList()
For Each Cell in Cells(1,1).CurrentRegion
If Cell lt;gt; quot;quot; then Cells(65536,12).end(xlup).offset(1,0) =Cell
Next Cell
End Sub--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=543444
You could try a macro like...Sub CreateList()
For Each Cell in Cells(1,1).CurrentRegion
If Cell lt;gt; quot;quot; then Cells(65536,12).end(xlup).offset(1,0) =Cell
Next Cell
End Sub--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=543444
Thanks, that worked well, but I wanted to have this make the list
automatically when I open the spreadsheet. I thought i could do this
with formulas.--
auspcs
------------------------------------------------------------------------
auspcs's Profile: www.excelforum.com/member.php...oamp;userid=34575
View this thread: www.excelforum.com/showthread...hreadid=543444