Relative Content

Tag Archive for excelvbaexcel-2010

Application.Match not recognizing matches

Have this long convoluted program, called when a cell in the relevant column on a given sheet is changed, for the purpose of identifying cases where there are duplicates in the WO value (column D) and keeping them together while sorting by other values (as an exception to the general sorting rules I am implementing), so long as their District value (column c) is the same. The way I am trying to do this is by using a helper column where (after all of the other sorting is done) I assign each row an integer in order, then if the program sees a duplicate WO value where the district is also the same, it changes the helper column value to the same number as the first instance of that WO in that district, and then the sheet will sort by that column last.

VBA move row based on multiple columns

I’m trying to move a row based on date to another sheet.
The code works and the row moves correctly, but only when all the fields are filled in with a date.

Hightlighting String from substring

In excel, how do I highlight parts of a string in column A, based on substring(s) from column B?
The substrings in column B can be in any order, not necessarily follow the order of string from column A