PDA

View Full Version : Move informaiton based on a match



Sandler
11-20-2017, 09:50 AM
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
11-21-2017, 04:48 AM
Supply a file with some data (de-sensitised if necessary) to experiment with.

Sandler
11-21-2017, 01:45 PM
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.