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

[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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"kayos" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> kayos
> ------------------------------------------------------------------------
> kayos's Profile:
http://www.excelforum.com/member.php...o&userid=23974
> View this thread: http://www.excelforum.com/showthread...hreadid=375975
>

[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