deleting sequential numbers

[kayos]

hey folks

I've got a row with a simple set of sequential numbers - 1-10.

I'm trying to figure out how, if possible, to have the row recalculate
the list of numbers if one is removed.

For instance, if I delete the number "3" from cell C1 I want all the
cells to shift over to the left so that the last cell in the row is
blank not cell C1.

Sorry, this seems a bit confusing so please let me know if I can
clarify further.

Thanks for any help
Keith

 

[Tom Ogilvy]

When you delete the cell, you should get the option to shift left

 

[Leith Ross]

Hello Keith,

Here is the VBA code to delete a cell or range of cells and shift them
left...

Range("C1").Delete(xlShiftToLeft)

I suspect you have more questions than this. Repost and I'll answer
them for you.

Sincerely,
Leith Ross

 

[kayos]

Thanks Leith for your help.

Yes, I have plenty of questions but I am trying to make Excel do what
it was not meant to do and may be in way over my head here.

If you are familiar with the textbook publishing business, you may have
heard of bookmaps which are literally a visual layout of what the final
textbook - sort of like using a storyboard for movies. It consists of a
series of rectangles that represent the pages with a page number and
some info regarding the content of that page so when you are putting
together a 250 page textbook, for instance, you have an idea of what
content will go where and how much space you will need.

Everyone I know that uses bookmaps usually creates them in Excel purely
because it's simple to create the layout of the pages by resizing the
cells. But the problem is that the page numbers can rise or drop
depending on the content of the pages so the page count can flex many
times throughout the project.
The bookmap needs to reflect these changes so when a page is removed or
added the bookmap has to be repaginated by hand which can be a
painstaking process when hundreds of pages are involved.

What I need is something that I can set up in a generic template that
they can use and fill in with the data they need and that can
repaginate itself.
It seems like the simplest of software but there is NOTHING out there I
can find or any application I can build it in. I've tried Filemaker,
Omnigraffle, Word, InDesign and GoLive but none of them can do what I
need them to do and that brought me back to Excel.(incidenmtally,
anyone with some coding skills could make a mint if they built this
damn software!)

I thought if I could figure out some calculations I might be able to
get it to work but I'm finding my skills to be fairly limited.
After applying your calculation, it occurred to me that that wont work
because there is a space between every two cells so just shifting
everything to the left wouldn't work and since the page number is in a
cell below the page it represents, both rows of cells would have to be
moved over.

Anyway, this may be too much to figure out so I don't expect a solution
if it is too complicated but if you would like to take a look at what I
am working with I have included an excel spreadsheet as an example of a
bookmap.

Thanks for your help

Keith


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