This one is a bit difficult for me to explain, so i included screenshots to help....maybe
I've have to cover some of the data as its personal information
https://imgur.com/cFDqyS8 source<source
<source (separate="" worksheet)
https://imgur.com/jdC0Ii9 destination<destination<destination (separate="" worksheet)
OK, so on the source you see column H, the last 3 characters are 300, i want the time part of the value in cell R to be copied to destination worksheet in column E
Now the tricky part, the destination worksheet has numbers ranging from 101 to 419, however they aren't sequential or go in ascending order
So what i need, is some kind of code which will look at all the values on the destination worksheet column A, and if it matches the last 3 character values in column H on source worksheet, it then copies the time value to the equivalent row in column E, if not it moves to next row
Im not sure if makes sense....
any guidance would be appreciated</destination<destination></source
I've have to cover some of the data as its personal information
https://imgur.com/cFDqyS8 source<source
<source (separate="" worksheet)
https://imgur.com/jdC0Ii9 destination<destination<destination (separate="" worksheet)
OK, so on the source you see column H, the last 3 characters are 300, i want the time part of the value in cell R to be copied to destination worksheet in column E
Now the tricky part, the destination worksheet has numbers ranging from 101 to 419, however they aren't sequential or go in ascending order
So what i need, is some kind of code which will look at all the values on the destination worksheet column A, and if it matches the last 3 character values in column H on source worksheet, it then copies the time value to the equivalent row in column E, if not it moves to next row
Im not sure if makes sense....
any guidance would be appreciated</destination<destination></source
Last edited: