Macro to PRIORITISE and CONSOLIDATE data across different sheets into summary sheet

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

Please Login or Register  to view this content.

I have no idea how that works but it does, Thanks a lot. How could I possibly divide that up further? for example in each line there is a fee in either year 1, year 2, year 3..... how could I then separate it out across different sheets so there would be a tab for each year, obviously some items would be copied several times as they are present in each year?


Many Thanks

Please Login or Register  to view this content.

Thanks again. but how would you copy only the details about each line and the value for that year as opposed to all of the values?

Thanks for your help your a life saver as I have about 40 surveys to edit and this is saving me a whole heap of time!