-
Move informaiton based on a match
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
-
Supply a file with some data (de-sensitised if necessary) to experiment with.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules