I want to copy data from another worksheet.
Example:
copy N3,N4,N5 of sheet2 to L3,L4,L5 of sheet 1
next step will be,
copy O3,O4,O5 of sheet2 to L6,L7,L8 of sheet 1
the same pattern continue...
another says i want to copy every 3 lines of one column in sheet2 and move to another column and copy another 3 lines and go on. The destination will be at one column in sheet1.
i have hundreds lines of data to be copied, i dont want to do it manually. Anyone has any ideas ?
Example:
copy N3,N4,N5 of sheet2 to L3,L4,L5 of sheet 1
next step will be,
copy O3,O4,O5 of sheet2 to L6,L7,L8 of sheet 1
the same pattern continue...
another says i want to copy every 3 lines of one column in sheet2 and move to another column and copy another 3 lines and go on. The destination will be at one column in sheet1.
i have hundreds lines of data to be copied, i dont want to do it manually. Anyone has any ideas ?