(If a thread already exist, please just direct me to it - I could not find one)
I have a master list that contains data in column A and B (not alphabetic nor in numeric order , but in a particular order)
I then have data in several columns of which the first column contains the same data as in Columb B of the master list. (The data's first column will always be in the same order as the master list, but will only match some of the master list).
I would like to paste the data next to the master list and then ran a macro to match and align the rows. In effect VB should enter blank cells were needed to the data to shift the data down to its correct position.
Any help appreciated.
I have a master list that contains data in column A and B (not alphabetic nor in numeric order , but in a particular order)
I then have data in several columns of which the first column contains the same data as in Columb B of the master list. (The data's first column will always be in the same order as the master list, but will only match some of the master list).
I would like to paste the data next to the master list and then ran a macro to match and align the rows. In effect VB should enter blank cells were needed to the data to shift the data down to its correct position.
Any help appreciated.
