Hi everyone
I have searched but cannot find an answer to my quest!
I have two sheets, sheet1 and sheet2.
On sheet 1 I have cells containing data but they are not consecutive. i.e. a4, b2, c3, d4, e5, j2, m9
I also have cell A1 on sheet 1 containing a number from 1 to 50 (starting with 1)
I need to copy the cells from sheet 1, and paste into the column number corresponding to the value in A1, with the pasted values in consecutive rows starting at row 4.. i.e. if A1= 3, the data would be pasted into column C rows 4, 5, 6, 7, 8 etc. with the number of rows being equal to the number of cells of data on sheet 1.
I then need A1 to increment by 1
I need the pasted cell to have the same format as the copied cell (text, general, date, time, number, etc).
Can anyone help please?
Bookmarks