+ Reply to Thread
Results 1 to 2 of 2

Loop and Copy to New Worksheet

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    18

    Loop and Copy to New Worksheet

    Hi Guys,

    Thanks for the help in advance, still learning how to do loops. I need help building a macro that loops.
    What I am trying to accomplish;
    I need to built a macro that will loop through cells D3:AQ101
    If the cell is blank just move to the next cell, if there is data present I need the macro to copy that piece of data into the “macro sheet” and paste it under ID.
    I also need the macro to copy the associated “name” from column B to correspond to copied data cell and paste it in the macro sheet in column B
    Example: If there is data in cell D6 “922126” and data in B6 “John Doe 4” in the list it should read:

    The macro would run for all data in the selected range and create this list.

    Thanks so much for the help guys!
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Loop and Copy to New Worksheet

    Give this a try

    Please Login or Register  to view this content.
    Last edited by mike7952; 03-03-2013 at 11:20 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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