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..
Bookmarks