If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying a column list from one sheet to another and repeating???
Hi
Does anyone know how to copy a list of text in a column from one sheet and display it in another sheet but then continue to repeat the original list? I am trying to get the content from these cells to be displayed in a row of cells but the crucial thing is that I need the cells to repeat the list from the beginning once a blank cell is reached in the original column. I'll try an example to make this clearer... 1. There is Sheet A with column A1:A20 containing the names of 20 products. 2. There is Sheet B with row A1:AN1 containing 40 cells In this example Sheet B should copy all the 20 product names then get to cell 21 and find a blank cell at 'Sheet1:A21' so start the list from the beginning again. This should occur no matter how many cells are calling the original list of 20 products but as soon as it finds a blank cell at the end of the list of 20 products it should go back to the beginning and start displaying from cell 1. Please note that there should be no limit on the number of cells in the original product list and the cells displaying the copied list should be able to be displayed in any row on sheet 2. Hopefully I've made it easier to understand and not harder. Any ideas would be much appreciated. Thanks Simon |
Thread Tools | |
Display Modes | |
|
|