In a page where rows are repeated how does cell data change?
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 |
In a page where rows are repeated how does cell data change?
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 |
In a page where rows are repeated how does cell data change?
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 |
All times are GMT +1. The time now is 01:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com