Hello:
I need a VB Macro to copy and certain data from Sheet2 to Sheet1
Copy O610:O625 from Sheet2 to Sheet1 at D1
Copy Q610:Q625 from Sheet2 to Sheet1 at E1
Copy S610:S625 from Sheet2 to Sheet1 at F1
Copy Q610:Q625 from Sheet2 to Sheet1 at G1
and so on...last column would be EG610:EG625
As you can see i need to copy alternate column data.
Please help and let me know if any questions.
Thank you
Riz Momin
Last edited by rizmomin; 07-08-2013 at 11:40 AM.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
so you want column o, s, u, w but Q stays the same in between them?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi AlphaFrog:
Your code works great.
Thank you so much for help.
RM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks