Results 1 to 9 of 9

Macro code to Copy specific rows into specific columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    65

    Question Macro code to Copy specific rows into specific columns

    Hi

    I am not a programming person...really struggling to write a macro. I am good for recording macros but not in programming. But I would really really appreciate if anyone can help me in solving my problem.

    I am trying to copy Extract-batch 13(sheet1 which is dp here) all the rows until a blank row comes to ShareWB (Sheet1, called DP again) from J column though to M in the sequence but I want this to be pasted exactly after the data column(In this case this is J14 to M14). For coding purpose if macro understand 'blank' column. I can say to paste it in the same sequence J to M where it encounter a blank (For J column in this case). After this I have to apply some formulas...but that I can manage. I just need the code for copy and paste..its not very simple I guess.

    This is a reconcilation tool. So I will be collating the data after each extract in the same sheet. And I have this to do for all the 4 sheets DP,RP,DC and RC.

    PFA the worksheets. (Extract-batch 13 and ShareWB).

    Thanks for looking and helping.
    Su.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1