+ Reply to Thread
Results 1 to 2 of 2

Copy and paste data in a loop

Hybrid View

rhudgins Copy and paste data in a loop 03-29-2010, 02:39 PM
excelxx Re: Copy and paste data in a... 03-31-2010, 05:05 AM
  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Copy and paste data in a loop

    Column F:R is how I would like the data copied for each of the 80 data sets that start in column T. I need a macro to loop through each example and copy and paste as values each row from columns U:AG into columns F:R.

    Next identify the ticker in column F and look up the appropriate basket for that ticker in the Long/Short Baskets Tickers starting in column AL. Then paste the basket into column F under the ticker.

    In column A number each example 1,2,3,4,ect..
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-04-2010
    Location
    Hertfordshire, England
    MS-Off Ver
    Office 2007 (home) Office 365 (work)
    Posts
    134

    Re: Copy and paste data in a loop

    Hi rhudgins

    Please find attached some code which would assist you in achieving your desired results.

    Regards
    Attached Files Attached Files

+ 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