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
|
|||
|
|||
Copy contents from one cell to another
Is there some Function that will move the contents of one cell to another?
I want to copy data from a static cell to another cell based on the value in the contents of another cell. For instance, I have a list of names in Alphabetical order in column 'A'. I have a list of whole numbers from 1 to 50 in column 'B'. The numbers in column 'B' will change order randomly when I recalculate (F9). I want to use this number to reference the cell in column 'A' and copy that name to column 'C', starting at 1 and work thru 50, thus jumbling the names. If the 1st number in column 'B' is 20, I would take the 20th name in column 'A' and copy it to the first cell in column 'C'. and so on down the line. Any help I could get, I would appreciate - Thanks. Don D. |
Thread Tools | |
Display Modes | |
|
|