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