Hello Everyone
I need code for if in column B starting in cell B2 it says Comment then insert XXX in columns D,E & F on the same row and then to repeat for all rows than have Comment in column B
Thank you in advance
Hello Everyone
I need code for if in column B starting in cell B2 it says Comment then insert XXX in columns D,E & F on the same row and then to repeat for all rows than have Comment in column B
Thank you in advance
Couple of ways:
Please Login or Register to view this content.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
from one manc to another, awesome job, exactly what I wanted
You're welcome. Thanks for the rep.
Whereabouts? Got to be honest and say we moved from South Manchester nearly 12 months ago and now live not far from Jodrell Bank.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
I'm not that far from the Trafford center , I'm outside the ring road and Jodrell bank aint that far from me either 20/30min drive.
Ah, I know it ... not well, but I've travelled round there quite a bit. Got lost there only a couple of weeks ago
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks