Searching and extracting data within a defined dataset
Hello
I'm trying to write some vba code to do the following, and would
appreciate any help/advice.
Within a predefined dataset (Range A3:H1000), run a conditional search
to find rows with a specific number in column B and a specific text
string in column F. If those two criteria are met, copy cells in
column E and H to the first blank row in another worksheet. Iterate
for all populated rows in the range.
Many thanks
Ben
|