• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to update status in one column based on several columns

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
 

Attachments

  • status update.xlsx
    19.2 KB · Views: 0
Back
Top