Hi, I need some help with a database im trying to set up.

The database is set up on inputting items. Each item will have a unique item code. What I want to do, is view all the items that appear more than once(but still eave the duplicated item numbers in the table).

In the table of information there will be a total of 7 colums with things like time, date, person inputting and such.

ideally i would like every entry that appears more than once to be moved into a different table on a new sheet.

appologies if this question has already been asked, i did look but couldnt see anything relating.