If you're not doing anything with that table except printing it, you could put
that table into MSWord. You can create columns (under Format|Columns), then
inserting/deleting elements into that table will do exactly what you want.

If you're really using that data in excel (although that layout sounds difficult
to use), I would put the data on a separate worksheet. I'd a two columns: Part
number and price.

Then I'd update that list in place and use a macro to layout the data on a
separate sheet. And I'd run that macro to recreate those "pretty table"
worksheets whenever I updated that giant list.



bilsons wrote:

I am trying to create a multiple page pricelist in Excel. The problem I have
is that I need to have three columns with 20 rows in each column per page. I
need the pricelist to be sequential on each column on each page. For
example, the first column would list prices for parts 1 through 20 in order
of the part number, then the second column would list the prices for parts 21
through 40, and the third column would list the prices for parts 41 through
60. Page two would start with parts 61-80, and so on. The problem I have is
that if I try to insert a new cell for a new part, it shifts every cell in
that column down on every page, which makes them out of order. Does anyone
know how to set up the spreadsheet so that values are entered in x cell to x
cell, then force the next value to move to column two, cell x through cell x,
then to column three, cell x through cell x, then on to page two, column one,
cell x through x, etc.?

--

Dave Peterson