VBA to change value only when between two other values

[brianfromla]

I have over 5,000 lines of data, and I will have the following scenario occur many times throughout:

SG EOS
SG
TOE OF DITCH

When the above 3 values display in 3 different cells grouped together like this, I need to change the value in the cell that just says SG to say DAYLIGHT. I'm needing VBA that will go through all 5,000+ lines of data and change these values.

I used to have something similar that I thought I would be able to change to work, but I can't find it and I could definitely use help with it.

Attached is a snip from the Excel file showing one of these areas circled.

Capture2.PNG

Thank you.

Edit: I guess the image isn't showing up...

[Olly]

It's all but impossible to work from a picture of a spreadsheet.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[StephenR]

Perhaps this, change range to suit

Please Login or Register  to view this content.

[Arkadi]

As Olly said, not easy to work without a real sheet.... but I took a stab at it making some guesses. Give this a go?

Please Login or Register  to view this content.