bifjamod
03-14-2016, 01:39 PM
I have a script that sorts my workbook by a certain set of criteria (call it MM-YY, column S), then by additional criteria first in Column R (value is 6 or 7), then by column O (a date). Once this sort is accomplished, I need to further sort all the rows where the column S value = this month (i.e. MM-YY) and the column R criteria = 7, by the values in columns F then V. I can manage the sort sequences easily enough; where I am completely stumped is how to "select" the rows where the columns S value matches the current month and the column R criteria is 7, from which to facilitate the sort.
Can anyone offer some guidance or a starter script I tinker with? I've been trying all kinds of variations of stuff I Google to no avail, and really appreciate any help anyone is willing to provide. My next stop is my VBA guru on Fiverr.com if nobody here has a solution for me.
Thanks!
Can anyone offer some guidance or a starter script I tinker with? I've been trying all kinds of variations of stuff I Google to no avail, and really appreciate any help anyone is willing to provide. My next stop is my VBA guru on Fiverr.com if nobody here has a solution for me.
Thanks!