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

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

Thanks!

"Kiba" wrote:

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

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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

You're brutal! Just enter them in by hand. Calm down! Forjust five minutes!

"MikeC" wrote:

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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

Mike

Re-think what you you're asking and re-post.

A1:A702 as a title would take about 12 or 13 pages to show.

A cover sheet for each row would give you 702 cover sheets.


Gord Dibben MS Excel MVP

On Fri, 18 May 2007 08:38:02 -0700, MikeC
wrote:

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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

What I was thinking was, making a coversheet for every row in my spread
sheet, where columns are different parts of the coversheet. For example, A1
would be the title, B1 would be the subtitle, C1 would be what was done...and
so on to E1, and repeat the process for row 2 and continued to row 702. Does
that make more sense? I'm sorry for the confusion. Let me know what everybody
thinks. Thanks a lot.

MikeC

"Gord Dibben" wrote:

Mike

Re-think what you you're asking and re-post.

A1:A702 as a title would take about 12 or 13 pages to show.

A cover sheet for each row would give you 702 cover sheets.


Gord Dibben MS Excel MVP

On Fri, 18 May 2007 08:38:02 -0700, MikeC
wrote:

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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

The 702 cover sheets is what I am looking for...so if there's anyway of
simplifying this by perhaps a macro? Please let me know.

Thanks,
Mike

"MikeC" wrote:

What I was thinking was, making a coversheet for every row in my spread
sheet, where columns are different parts of the coversheet. For example, A1
would be the title, B1 would be the subtitle, C1 would be what was done...and
so on to E1, and repeat the process for row 2 and continued to row 702. Does
that make more sense? I'm sorry for the confusion. Let me know what everybody
thinks. Thanks a lot.

MikeC

"Gord Dibben" wrote:

Mike

Re-think what you you're asking and re-post.

A1:A702 as a title would take about 12 or 13 pages to show.

A cover sheet for each row would give you 702 cover sheets.


Gord Dibben MS Excel MVP

On Fri, 18 May 2007 08:38:02 -0700, MikeC
wrote:

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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

I'm still confused........easily confused is my forte.

What do you consider a "cover sheet"?

A printed page with only A1:E1 on first page and A2:E2 on second page and so on
for 702 pages?

Could be done but that's a great lot of trees<g

I'm up here in Beautiful British Columbia and we're running short unless you
want Pine Beetle-killed pulp.


Gord

On Mon, 21 May 2007 11:55:01 -0700, MikeC
wrote:

The 702 cover sheets is what I am looking for...so if there's anyway of
simplifying this by perhaps a macro? Please let me know.

Thanks,
Mike

"MikeC" wrote:

What I was thinking was, making a coversheet for every row in my spread
sheet, where columns are different parts of the coversheet. For example, A1
would be the title, B1 would be the subtitle, C1 would be what was done...and
so on to E1, and repeat the process for row 2 and continued to row 702. Does
that make more sense? I'm sorry for the confusion. Let me know what everybody
thinks. Thanks a lot.

MikeC

"Gord Dibben" wrote:

Mike

Re-think what you you're asking and re-post.

A1:A702 as a title would take about 12 or 13 pages to show.

A cover sheet for each row would give you 702 cover sheets.


Gord Dibben MS Excel MVP

On Fri, 18 May 2007 08:38:02 -0700, MikeC
wrote:

Perhaps I should be a little more specific. An example would include A1:A702
would be the title, and every corresponding row would be a different cover
sheet. Thanks in advance.

MikeC

"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