I have a main sheet, in which some information is asked and the data is saved in the next sheet. Now, there's this field in main sheet as 'revision no.', and every time I enter a new value to the cell, say, R0, R1, R2.... a new sheet should be created. And any changes made in the 'data' sheet thereafter should be stored in respective revision sheet.
For e.g.: If currently R1 is typed in the cell, and I make some changes in the 'data' sheet, its history will be reported in 'R1' sheet.
For e.g.: If currently R1 is typed in the cell, and I make some changes in the 'data' sheet, its history will be reported in 'R1' sheet.
