explain in detail your goal. Not getting ur problem exactly.

do u want to find duplicate record and than change one field value to
distingush between them???

"pk.anees SSPM India" wrote:

In a workbook where the rows are repeated how can one change the data of a
particular cell within the rows repeated in different pages of a worksheet