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

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

If I understand you then placing a reference on each sheet to the main sheet
would cause the values to change.

So on sheet 1, you have say "MyText" in cell A1, on all other sheets you
can add =Sheet1!A1 in the cells you wish to the text "MyText" as the linked
cell. Changing sheet 1 cell A1 will be reflected into all other sheets with
the above link..

If you wish to have a value change in all linked cells wherever you make a
change, then it will require some VBA code, that detects the change and
applies it to all other linked cells. Repost if this is your problem.


--
Cheers
Nigel



"pk.anees SSPM India" <pk.anees SSPM wrote
in message ...
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