I have a work book that contains surveys from three different sites. Im trying to get a macro to prioritise the data by its condition and copy the data onto a summary sheet at the beginning. I don't want the original data to be altered.
Basically the summary would be all grade D4 down to A1, then the next site in order of grade and so on. I'm really struggling to figure out how to search for the data let alone copy it.
I would appreciate a point in the right direction or if your kind enough to solve it you would be a hero
thank you in advance
JimCondition Survey template.xls
Bookmarks