Lieke
10-22-2008, 01:04 AM
Hi,
Can anyone help me with the following problem?
I have my data in three columns, but now in need to copy data from 1 specific cell in the third column to 49 cells in the first column, but for a large number of cells:
I have to copy the contents of cell C1 to cells A2 through A51, then the contents of cell C52 to A53 through A102, the contents of cell C103 to A104 to A153, the contents of cell C154 to A155 through A204 and so on, until the end of sheet.
Can anyone figure out a way to do this with VBA?
Thanks,
Lieke.
Can anyone help me with the following problem?
I have my data in three columns, but now in need to copy data from 1 specific cell in the third column to 49 cells in the first column, but for a large number of cells:
I have to copy the contents of cell C1 to cells A2 through A51, then the contents of cell C52 to A53 through A102, the contents of cell C103 to A104 to A153, the contents of cell C154 to A155 through A204 and so on, until the end of sheet.
Can anyone figure out a way to do this with VBA?
Thanks,
Lieke.