If your cover sheet is in a seperate sheet from the data then an equation
like this will work to pull the value from a different sheet in the workbook.
< =Sheet3!D6 . With this formula (=SheetName!cellreference) if the cell
you refence is blank then it will display a 0. To fix this I would recomend
an if statement such as =if(Sheet3!D6="", "", Sheet3!D6). The "" means
blank. Hope this helps.

"MikeC" wrote:

I want to take my spreadsheet and take each column and place it on different
areas of a cover sheet. Is this even possible? For example, A1 would be the
title...E1 would be the abstract, something of this nature. Your help is
greatly appreciated.

Thanks,

MikeC