handling duplicate entries

heyy.....i am working on a project, which deals with tenders,,(we float tenders in newspaper and contractors provide us their rate for the required spare..thn the lowest rate is considerd)...all the record is on one sheet..almost 10,000+ rows and 10 columns...
problem is:
1. i want to copy all the duplicates to new sheet..(these spares hav price column at the end,,there are some spares who may hav duplicates values in 1-9 columns bt differ in the last price column..i want to copy those values tooo.. ) m attaching sample of my sheet..

sania tariq,

Welcome to the forum.
Could you provide a better example.
A before and after example would be great.
Your explanation is a little sparse.

sania tariq,

OK, I get the part about sending the row for duplicate to another sheet, but, I'm still lost.
Are you wanting to set a filter for each column A-E" Or, you want to filter "A" and "E"?
Could you provide a sample as to what the filtered data would look like.