Match up data based on pre-existing data

[thechad]

Greetings,

I would like to develop some code that would line up rows of data with cells that have matching values in column B & C on the same row. Clear as mud I know!!!

It would be easier with a picture!

Anyway...I have a list of badge numbers in column B, rows 7 thru 11 as 1,2,3,4,5. Data is manually pasted to the right of column B in column C with badge numbers in column C and other data from column D to I. The badge numbers in column C will typically be the same as column B but in a different order (i.e. 5,4,2,1,3). I would like the code to line up columns B & C badge numbers and all the information from columns D to I being sorted accordingly. Also, if there are additional badge numbers in column C that don't appear in column B, I would like them, along with column D to I information being placed at the bottom of the list.

I hope this is understandable.

Thanks!!!!

 

[AFPathfinder]

Where is the column C:I being copied from? With VBA, I think it would be easier to match during the transfer than after.

Range("C7:I11").FormulaR1C1 = "=VLOOKUP(RC2,Sheet1!R1C1:R500C7,COLUMN(R[1]C)-1,FALSE)"

For find the unmatched values, you'll want a loop to check if the value exists and copy it over if it doesn't.

 

[thechad]

The information in C:I is being manually pasted from another program as values only.

 

[AFPathfinder]

I'd suggest a 2D array to hold the information that was manually pasted in C7:I11. Then, a loop to compare badge numbers for each row; pasting the data to the sheet and removing the data from the array. The left over would then be input into the blank rows that follow the previous pasted data.

 

[thechad]

I have nooooo idea how to do that!!!!

 

[AFPathfinder]

OK, let's take it step by step. What's the first snag in your solution? Have you started the macro, yet?