Hey folks

this is a bit of a long shot but maybe someone can guide me on th
right path.
If anyone is familiar with the textbook publishing business, you ma
have heard of what is called bookmaps. It is literally a layout fil
that contains a series of rectangles that represent the pages involve
with the book so when you are putting together a 250 page textbook yo
have an idea of what content will go where and how much space you wil
need.
Everyone I know that uses bookmaps creates them themselves in Excel fo
the simple reason that it is easiest to use the cells to make "pages
and comment fields below them. The problem is that the page numbers ca
rise or drop depending on the content of the pages so the page count ca
flex many times throughout the project. Then the cells of the book page
have to be repaginated by hand each time the page numbers change whic
can be a painstaking process when hundreds of pages are involved.
I have included an example of the bookmap with this posting.
Is there a way to make the cells automatically renumber themselves whe
a cell is removed. For instance - if I have cells numbered 1 throug
ten, then remove cell 8, can the cells be set up to automatically tur
cell "9" into "8", "10" into "9", etc.
I realize this may be a bit confusing and perhaps isn't th
apoplication to do this with but there is literally NO other existin
software out there that will do this and I don't have the codin
experience to write anything.

Thanks for any help
Keit

+-------------------------------------------------------------------
|Filename: bookmap.xls.zip
|Download: http://www.excelforum.com/attachment.php?postid=3449
+-------------------------------------------------------------------

--
kayo
-----------------------------------------------------------------------
kayos's Profile: http://www.excelforum.com/member.php...fo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37595