View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Burns Ben Burns is offline
external usenet poster
 
Posts: 6
Default 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