I'm trying to extract key information from a range; below is an example of a sample data set I'm working with (unique IDs can exceed 100, unique Types can exceed 10, Value is variable). The source data is random with each sampling but always arranged by Value, Type, ID. I need to extract the Values associated to Type 2 & 3 (always 2&3) for each ID and then copy those Values to the Destination cells according to ID and Type.
So the macro needs to look at the source data and find Type 2&3 in column 2 then take the Value associated with it in column 1 then cross reference the ID# in column 3 and copy those two Values then past them into the destination cells for the Type 2&3 Values that are associated with each ID#. For users with no Type 2&3 Values blank cells are fine.
You can assume source columns are A, B C and destination columns are E, F, G . I can manipulate these values to make it put the data where I need it.
I already have a method for finding the unique IDs and creating the "destination". But this multiple variable reference is beyond my current skill set. I've seriously been hurting my brain for a couple weeks on this one.
Thanks for anyone who can point me in the right direction.
<tbody>
</tbody>
So the macro needs to look at the source data and find Type 2&3 in column 2 then take the Value associated with it in column 1 then cross reference the ID# in column 3 and copy those two Values then past them into the destination cells for the Type 2&3 Values that are associated with each ID#. For users with no Type 2&3 Values blank cells are fine.
You can assume source columns are A, B C and destination columns are E, F, G . I can manipulate these values to make it put the data where I need it.
I already have a method for finding the unique IDs and creating the "destination". But this multiple variable reference is beyond my current skill set. I've seriously been hurting my brain for a couple weeks on this one.
Thanks for anyone who can point me in the right direction.
Source | Destination | |||||
Value | Type 1 | ID 1 | Type 2 | Type 3 | ||
Value | Type 2 | ID 1 | ID 1 | Value | Value | |
Value | Type 3 | ID 1 | ID 2 | |||
Value | Type 4 | ID 1 | ID 3 | Value | ||
Value | Type 1 | ID 2 | ID 4 | Value | ||
Value | Type 5 | ID 3 | ||||
Value | Type 3 | ID 3 | ||||
Value | Type 2 | ID 4 | ||||
Value | Type 6 | ID 4 |
<tbody>
</tbody>