Hoppbananen
New Member
- Joined
- May 4, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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!
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!