Move informaiton based on a match

[Sandler]

Hi friends,

I have information in columns A:M and information in columns S:Z.

I need to move the S:Z row based on a match between columns B and columns T.

So for example in column B, I have "Construction Truck" in Row 98

In column T, I have "Construction Truck" in Row 140. I would need this program then to move S140:Z140 to S98:Z98.

I would need this program to Loop through all of Column T and move the information into the respective row that matches in Column B.

It also, can't overwrite any of the information.

Please, help

[p45cal]

Supply a file with some data (de-sensitised if necessary) to experiment with.

[Sandler]

Thanks p45cal, for this project, I ended up doing it manually due to timing.

But I will definitely revisit this, try to go through the web to figure it out, and if I can't figure it out, I will reach out again.