Hi ,
I have a excel workbook which has 60+ sheets. In that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc..
Against the column A in column B I have attendance value like 50 in sheet 1, 60 in sheet 2, 90 in sheet 3,etc..
I have a separate sheet of SAM's attendance value for all 60 sheet. So if I need to change the value of SAM's attendance in all sheet I need a formula by which I can make a change in single sheet which will make the change in the corresponding sheet.
Thanks in advance !
I have a excel workbook which has 60+ sheets. In that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc..
Against the column A in column B I have attendance value like 50 in sheet 1, 60 in sheet 2, 90 in sheet 3,etc..
I have a separate sheet of SAM's attendance value for all 60 sheet. So if I need to change the value of SAM's attendance in all sheet I need a formula by which I can make a change in single sheet which will make the change in the corresponding sheet.
Thanks in advance !