Copy records with range

[MC09]

I need to copy records in a worksheet. First I need to look for value1 and move 2 rows after it. Then I will look for value2 and that's where I will stop my copying. And then I will look again for value1 and so on.

For example

Value1 = A4
Value2 = A8
Range to copy = A6:A8

Value1 = A14
Value2 = A19
Range to copy = A16:A19

Thanks in advance for any help. In addition, the lookup reference is column A only.

 

[Richard Schollar]

Hi

Do you have duplicated values in column A? So if you have Value1 you are looking for, it may occur in row 10, row 100, row 1000 and row 2000? Then you would want to search for 4 instances of Value2 as well? Or is it simpler than this - there will only be one unique instance of each value?

 

[MC09]

Hi

Do you have duplicated values in column A? So if you have Value1 you are looking for, it may occur in row 10, row 100, row 1000 and row 2000? Then you would want to search for 4 instances of Value2 as well? Or is it simpler than this - there will only be one unique instance of each value?

yup, value 1 and value2 are duplicates. Value1 may occur in row 10, row 100, row 1000 and row 2000. Then value2 may occur in row 20, row 150, row 1200 and row 3000. Thanks.