Related:
- Automatically replacing a value in an excel report
- Excel report card generator - Forum - Excel
- Automatically Replace Abbreviations in Word - How-To - Word
- How to automatically write numbers in words in excel - How-To - Excel
- How to automatically create a new sheet in excel - How-To - Excel
- Need urgently to find a macro in excel report across sheets ✓ - Forum - Excel
4 replies
TrowaD
- Posts
- 2696
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 28, 2021
Hi Nazcarr,
I guess this one slipped my attention.
You could just use the Find&Replace option (Ctrl+H) and make sure to mark the option for identical cell value.
Or use the code below:
Best regards,
Trowa
I guess this one slipped my attention.
You could just use the Find&Replace option (Ctrl+H) and make sure to mark the option for identical cell value.
Or use the code below:
Private Sub Worksheet_Change(ByVal Target As Range)
For Each cell In Range("E2:E" & Range("E1").End(xlDown).Row)
If cell.Value = "Standard" Then cell.Value = "Request for a New Standard Change"
Next cell
End Sub
Best regards,
Trowa
TrowaD
- Posts
- 2696
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 28, 2021
Hi Nazcarr,
Could you show us how your CAB report looks?
Best regards,
Trowa
Could you show us how your CAB report looks?
Best regards,
Trowa
NazCarr
- Posts
- 13
- Registration date
- Monday March 25, 2019
- Status
- Member
- Last seen
- January 26, 2021
Hi Trowa,
My sincere apologies for the lack of response on my part! I got pulled off this piece of work and had to focus on something else - Covid has us all on our toes! I have inserted an image of what the excel spreadsheet looks like. The highlighted bit comes in as "Standard" and I am having to manually retype this as "Request for a New Standard Change"
Many Thanks,
Naz
My sincere apologies for the lack of response on my part! I got pulled off this piece of work and had to focus on something else - Covid has us all on our toes! I have inserted an image of what the excel spreadsheet looks like. The highlighted bit comes in as "Standard" and I am having to manually retype this as "Request for a New Standard Change"
Many Thanks,
Naz
Subscribe To Our Newsletter!
