Loop through range, copy paste to new workbook

[Hoppbananen]

Hey!

So I have this problem...

I have a table of data that I need to loop through and look for two different values in column A (Range A:H). For example, if value in cell A2 is 1 (can be 1 or 2) I need to copy all values in A2:H2 to a new workbook and also adding a value in cell I1 of the new workbook.

Depending on the value in column A of the original workbook, I need to paste the same range four or six times with four or six different values in cell I1 of the new workbook, then go on to next row of the original workbook.

Does this make sense? Really hoping for some help!

 

[Zot]

Many people viewed but people just don't like guessing. Perhaps copy paste (use XL2BB preferred) actual sample and some explanation will get more people to start looking more into it.