excel 2000

[Frankenherder]

OK, I have a list with 4 colums being used. Date, Time, name etc.....

There are 80 lines of data.
Is there a formula or something I can use to have it automatically use the left side of the page for 1-40, then the right side for 41-80? I guess I want the page to be 8.5 by 11 but with 2 cloumns like a newspaper and have the data automaticaly go to the top of the 2nd column before it goes to the 2nd page.

Any ideas? i do not really want to cut and past as I would like to maintain the columns for sorting abilities too.

Thanks
Matt

 

[AnotherHiggins]

I'm not sure if I understand your question. It sounds like all you want is to fill in the numbers.

If that's the case, then in whatever row you want to start on in column A, type 1.

Hover the cursor over the bottom right-hand corner until the it changes to a bold black plus sign (+). The press and hold [Ctrl] while Left clicking the mouse and Draging down 40 rows.

Repeat in a different column, starting with 41.

Note: You could use =Row() to return the row number, but that would be useless for sorting, since it will always return the current row.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[macropod]

Hi Matt,

Assuming you data start in A1 on Sheet1, insert the following formula in A1 on a new sheet and fill to H40:
=OFFSET(Sheet1!$A$1,ROW()-1+INT(COLUMN()/5)*40,MOD(COLUMN()-1,4))

Cheers

[MS MVP - Word]

 

[Frankenherder]

OK, I tried the formula but I get an error.

I have since consolodated my data. I have 3 work sheets that the cells link to a 4th sheet. There are now 2 colums of data I need.
Can I get A and B 1-50 then have the next line of info that should have went to A and B 51 go to C and D 1?

I hope this makes sense.

Thanks
matt

 

[macropod]

Hi Matt,

The formula works as advertised for a 4-column list! I've just re-tested it to confirm. Thus, if you've got 4 columns with 80 data sets starting at A1,B1,C1,D1, the output sheet will have 8 columns with 40 data sets starting at A1,B1,C1,D1,A41,B41,C41,D41.

I don't understand your 'revised' data structure. Do all the data exist on any one worksheet as a single set of 4 columns?

Cheers

[MS MVP - Word]

 

[combo]

It may be easiest to use printer properties if they are available:
- use, if necessary, hard page breaks (in page break preview),
- in page setup set printing order to horizontal,
- set two pages per sheet in printer setup.
Anyway, this method does not print page numbers properly.

combo