I have data in some sheets (the same data can be repeated in different
sheets)..I want to compile distinct records from these worksheets into
another sheet...prefereably using vba code.
I do not want to use a formula...since once i get the distinct data...i want
to use vlookup to get sales figures and then sort the data on sales...
I also want that the data automatically gets sorted in the compiled sheet in
desc order.
Plz help.
Nikhil
Bookmarks