Copy paste data based on criteria in a loop

**rhudgins** · 03-23-2010, 02:12 PM

Column A:Q 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 T:AE into columns F:Q.

Next here is the copy and paste codeing for the data that does into Columns B:D

(Old Rating Code)
If column Z= "Overweight" then paste "Buy" into column D
If column Z= "neutral" then paste "Neutral" into column D
if column Z= "underweight" then paste "Sell" into column D

(New Rating Code) Next do the same copy and paste procedure for columns Y and C

The next part of codeing relies on a number of if statements

IF column C="Buy" and column D ="Neutral" then paste "Long" into column B
IF column C="Buy" and column D="Sell" then paste ""Long" into column B
IF column C="Sell" and column D="Neutral" then paste "Short" into column B
IF column C="Sell" and column D="Buy" then paste "Short" into column B
IF column C="Neutral" and column D="Buy" then paste "Short" into column B
IF column C= "Neutral" and column D "Sell" then paste "Long" into column B

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 AK. Then if the code in column B="Long" the paste the basket into column F and call those tickers "Short Basket" in column B. If the code in column B="Short" then paste the basket tickers and call them "Long Basket" into column B.

In column A number each Long/Short followed by Short/Long Basket 1,2,3,4,ect..

Any help with this would be great! I have a lot of pressure on me and I really need this for a work project asap.Thank you so much it is greatly appreciated!