+ Reply to Thread
Results 1 to 4 of 4

Copy/past and 18 line jump

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    france
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy/past and 18 line jump

    I am novice in VBA and I fight a little to arrive has to make what I want:

    Here is the situation:
    A Sheet " Result ": I have a name of equipment and the rest of the information has to fill with other tabs
    Information is of the " old ", " current ,"date change, "...

    Example of tab "Source":
    I want to copy the information in corresponding compartment has the equipement in the resultat sheet. The 1st line of information goes to a line and the following one owes positionner18 lines more low may begin again the action to has the line 329 of the sheet "Source"
    I have just make the action of copy:

    Please Login or Register  to view this content.
    Now I wish to repeat this action to source has the line 329 of the tab and by jumping 18 lines has every time in the result sheet.
    What is what somebody can depanner me?

    Thank you in advance,
    Best Regards,
    Last edited by arlu1201; 03-15-2013 at 04:19 AM. Reason: Use code tags in future.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy/past and 18 line jump

    Do you have a sample file that you can attach?

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-15-2013
    Location
    france
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy/past and 18 line jump

    No sorry, I can't attach my file because it's confidential.

    Do you more explication to understand?

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy/past and 18 line jump

    You do not have to attach your original file. Just a mock up will do with the same format as the original.

+ Reply to Thread

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