Hello. I want to copy cells from row 1 (starting in A1) into row 2 (starting in B2) but I want to copy every 10 cells from row 1 and then skip a cell in row 1 and copy 12 cells, skip 1, copy 12, and so on. How can I write vba code!!
Hello. I want to copy cells from row 1 (starting in A1) into row 2 (starting in B2) but I want to copy every 10 cells from row 1 and then skip a cell in row 1 and copy 12 cells, skip 1, copy 12, and so on. How can I write vba code!!
Why VBA?
write some test data in A1, B1, C1 ... (say 1 2 3 ...
than in any (but row1) cell formula:
Formula:Please Login or Register to view this content.
and copy right - you will get 1...12,14... 25,27 ...
Best Regards,
Kaper
That didn't work. Let me show you what I want.
The file has quite different data layout than in first post (... copy cells from row 1... copy 12 cells, skip 1, copy 12...)
But solution can be similar.
In B1:
and copy down.Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks