Results 1 to 4 of 4

Copy & Paste Values in a Loop

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Copy & Paste Values in a Loop

    In the range A58:X93 is Trade #1, in the range Z58:AW93 is Trade #2. My worksheet will have many more Trades added over time. In the first column of each Trade in row 60 is the day count. Starting with the first Trade, if this day count is equal to 1 then I need a macro that can copy E59:E88 and paste that range as values to G59:G88. I need the macro to be able to loop through every trade and perform this action on the appropriate ranges for each trade. Can anyone help me with this? Thanks
    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