organize

Originally Posted by podboq

Hi ,first af all i have to ask you to apologise my english

i have to organize my worksheet.
i have to copy the values from a column and paste them in another sheet.
in this new worksheet columns cannot be longer than 50 cells.
i have only 5 columns for page and when i fulfill them i must start a new page.

can i do this?

or not?

can you attach a sample with some more explanation of your requirement?

Originally Posted by podboq

ok i try.

i have on the first file in column A thousand values

i want to copy these values in a new file
but in this file a must have
in column A: 50 values
in column B: 50 values
in column c: 50 values
in column d: 50 values

when i fulfill this columns i want to go to the next page and do the same

in column A: 50 values
in column B: 50 values
in column c: 50 values
in column d: 50 values

till the end of the list

is it possible?

Hi see following thread, this might help you.

http://www.excelforum.com/showthread.php?p=1766880