ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Repeating Columns (https://www.excelbanter.com/excel-worksheet-functions/103890-repeating-columns.html)

Joel Reeves

Repeating Columns
 
I need a way for the columns in Excel to repeat. Let me explain. Pretend
the excel spreadsheet is a piece of paper. I would like to wrap that piece
of paper around a cylinder so that if you turn it, the pattern repeats to
infinity. I hope I have made this clear enough. A reply with answers or
more questions would be greatly apreciated.

Mariuks

Repeating Columns
 
As I understand you would like to get list which repeats in a column?
as it would be from monday to sunday and then again?
so in this way you should create custom list
Tools | Options | Custom list
"Joel Reeves" <Joel wrote in message
...
I need a way for the columns in Excel to repeat. Let me explain. Pretend
the excel spreadsheet is a piece of paper. I would like to wrap that
piece
of paper around a cylinder so that if you turn it, the pattern repeats to
infinity. I hope I have made this clear enough. A reply with answers or
more questions would be greatly apreciated.




Gord Dibben

Repeating Columns
 
An Excel worksheet is 2 dimensional with finite boundaries east/west and
north/south and cannot run to infinity.

You can copy a column untill you run out of columns to copy to.

Your description leaves this writer scratching his head.

Do you want to try again?


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 11:57:01 -0700, Joel Reeves <Joel
wrote:

I need a way for the columns in Excel to repeat. Let me explain. Pretend
the excel spreadsheet is a piece of paper. I would like to wrap that piece
of paper around a cylinder so that if you turn it, the pattern repeats to
infinity. I hope I have made this clear enough. A reply with answers or
more questions would be greatly apreciated.




All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com