Suresh Badhani
Member
I have to daily updated new remarks if Attempt 2 Date & Attempt 2 Remarks,Attempt 3 Date & Attempt 3 Remarks,Attempt 4 Date & Attempt 4 Remarks so on 5 & 6 are blanlk
from last two coloumns L & M where new data is avl for these id
as
1st it will chk of attempt 2 ( B Col) if attempt 2 balnk
then we update in Attempt 2 Date,Attempt 2 Remarks from last two coloumn L & M ( Updated remarks),
then chk to next
2nd will chk of attempt 3 ( D Col) if attempt 3 balnk
then we update in Attempt 3 Date,Attempt 3 Remarks from last two coloumn L & M ( Updated remarks), also rest from step 1st updates
then chk to next
So in repeat for attempt 4,5,6 so on till last updated remarks all fill in Attempt 2,3,4,5,6
I have color code as this will go in blank cell
1st yellow color 2 attempt blank
when this will done now yellow color will not blank
2 green 3 attempt
so on
from last two coloumns L & M where new data is avl for these id
as
1st it will chk of attempt 2 ( B Col) if attempt 2 balnk
then we update in Attempt 2 Date,Attempt 2 Remarks from last two coloumn L & M ( Updated remarks),
then chk to next
2nd will chk of attempt 3 ( D Col) if attempt 3 balnk
then we update in Attempt 3 Date,Attempt 3 Remarks from last two coloumn L & M ( Updated remarks), also rest from step 1st updates
then chk to next
So in repeat for attempt 4,5,6 so on till last updated remarks all fill in Attempt 2,3,4,5,6
I have color code as this will go in blank cell
1st yellow color 2 attempt blank
when this will done now yellow color will not blank
2 green 3 attempt
so on