Hi,
I've been sifting through all the posts but could not find a macro that does the following exactly:
The macro will identify whatever ID is inputted in any cell, then copy all of its respective data from the data sample, then sort it according to date.
There should only be one date per column and one ID per row. The result will match its respective ID and placed in its appropriate cell. The ID may be a combination of letters and numbers. Also, this is a small sample size and if someone can figure out how to implement it using the max allotted rows for excel 2010.*
data sample:
ID 1/1/2012 1/3/2012 1/2/2012
AAA 14 12 11
AAA1 25 23 21
AAB 30 32 34
BBB 40 46 42
BBB2 57 50 58
CCC 69 62 64
CCB 70 73 77
CCC2 84 85 83
output:
1/1/2012 1/2/2012 1/3/2012
BBB results
BBB2 results
AAA results
CCC results
AAA1 results
CCC2 results
AAB results
CCB results
Bookmarks