Could someone please help me with a macro which would change all values "<-10" and ">25" to 0 in columns C:BT, but only in those rows where column B contains word "Deviation"?
The data looks as shown on the screenshot below, I have also attached a sample of the main spreadsheet.
screen.PNG
Kind regards
Not a solution to your problem, but I noticed you work with merged cells.
My advice is NOT to work with merged cells, you get in troubl with it sooner or later.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Please Login or Register to view this content.
stnkynts, thank you very much for your reply, the code works like a charm!
Hi, I have a similar need. I have a list of data in column A that contains text values. I need to find all the ones that contain the text "(Federated)" or "(CDK)" and replace the values in column B with the same value - say 1234
@pookyman; Please start a new thread of your own.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks