OK, I'm going to hit you guys up for two macros. I'm hoping that my project is nearing completion.
- Delete all rows where the first character in either one of columns C or D are “X,” with the other column possibly being blank. Note – the remaining columns need to remain in the same order, so sorting is probably not an option unless we can restore them to their original order.
- This is going to be a little complex: referring to the row in workbook named 171, sheet “Smith,” the row that has “MSB” in column D, if the value in column R <= 10, or is blank, place an “X” in cell A5 of workbook named “Orange”, sheet named “Apple,” otherwise copy that value to Cell C7 of workbook named “Orange”, sheet named “Apple,”