I have created a workbook in Excel 2002 that has 4 worksheets. 2 of
them interact with each other. One of the worksheets is for a client
to enter detailed data into and the other automatically populates from
some of the first worksheet. My problem is with the worksheet that
basically just contains formulas in order to bring the data over from
the other worksheet. I need to be able to do 2 things that I can't
seem to do together. I need the data to be brought over and if the
cell is blank I need it to return an empty cell, not a 0. I used a
logical value formula to do that, but then because of the default
sorting, when I try to sort the list alphabetically it puts all of the
blank cells first (TRUE before FALSE). I need to find a way to
populate the worksheet with data and still be able to sort
alphabetically and not have a bunch 0's in the cells that brought over
"blank" data. Any ideas? Does this post even make sense? It's hard
to describe without being able to show it to you.

Jessica