how to copy only 7(n values) cells from the list of cells and loop till end of cell with VBA : how to copy only 7(n values) cells from the list of cells and loop till end of cell and to be pasted in the next sheet(target sheet) with vba. Please help on this, its urgent.
Ex: values in vertical
1113456
1311456
1509456
1707456
1905456
2103456
2301456
2499456
2697456
2895456
3093456

