kingsley park
New member
- Joined
- Jul 26, 2016
- Messages
- 14
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2007
I have attached a worksheet to show an example of raw data in sheet1 and the solution i require in sheet2 from this data.<br><br>The code would go down sheet 1 identifying matching rows (these occur always when the first 3 columns are identical). In the example this first occurs in rows 3 and 4 in sheet1. All Data from the first matching row is returned to sheet2 in 11 columns (a to k), the next row in the match (row 4 in sheet1) is then transferred to sheet 2 starting at column L. The only difference with this 2nd row of the match is that columns a to c need not be transferred from sheet 1 as these columns will always relate to each part of the data match.<br><br>This is probably sounding more complex than it should but the example shows exactly what is required<br><br>The rules is that the first row of the match will always be 11 columns of data sent to sheet2 (a to k) and the other matching row data will always be in blocks of 8 columns as shown, to be placed adjacent until all parts of the match are complete.<br><br>The dimensions need to allow for about 2500 rows in sheet1 and perhaps up to 8 matches sent to sheet 2 which would be (1*11 +7*8 columns =67 columns) this is the most i have ever come across so again there would need to be flexibility on sheet 2 to accommodate this possibility.<br><br>I hope this is easily understood and would be very grateful for a solution.<br><br>Thanks in advance<br>Paul