Copy & Paste Values in a Loop

**rhudgins** · 04-05-2011, 01:06 PM

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

**TMS** · 04-05-2011, 01:18 PM

Your application requires updates from an external link/application and I do not recognise it so I'm not enabling it. Consequently, I can't really test your workbook.

That said, I can't help thinking that the way your workbook is structured will cause you difficulty in the future and is not scaleable.

I would recommend that you have all data from all trades in one set of columns and have your analysis on separate sheets or generate Pivot Tables.

Regards