PDA

View Full Version : Same number of trades



Lartk
10-17-2012, 09:06 AM
See the attached. See how row 2 and row 5 have the same number of trades for cusips on two different days. Is there a way to write a code that searches for the same sequence and pulls them and puts them on sheet 2? So for example, on 10/16..the sequence was 12312752. This also appears on 10/14. So is there a vba code that could recognize all the numbers in cells B through I and see if those same numbers exist during another trading day? I am looking for a way to manipulate data series? As you can see, in row 5, its the same numbers just in the same order..but they may not always be in the same order. So as long as the same numbers exist in the from column B to I, pull those rows (from A to I) and place them on sheet 2.

patel
10-17-2012, 10:39 AM
attach a file with before and after future macro execution