Hi
Is there a way of collecting information from 9 sheets and putting in a logical way. I have attached a document which has a sample of a table on sheet "E" I will have 8 other sheets named E1-E8, they will all have similar data and the data in the rows are all rated 0 to 3, i would like to collate all ratings together like all the 0's all the 1's etc.
hope someone can help.
thanks
Bookmarks