Hi
I need to select the entire row when two conditions are met,
Need to select in between range first condition and second condition
Eg: First condition is in Range("a2")
Second condition is in range ("a14") then
I need to select entire row from Range("a2:a14") and the copy the selected range irrespective of the blanks in between.
Please find the sample file attached.
Bookmarks