move text using vba

Hello expert,

I have a code that transfer a number into a different file, but now I want to use it to transfer a text instead.

Do you have a solution for my problem.

I already attached the file and the solution that I need in there. the code was already in Feedmaster## file.
I have no idea how to modify the code to identify a text instead a number.

Thanks.,

Originally Posted by davesexcel

From what I see your column T is only text, why do you need to identify as text?

because my current code just identify a number, so the text wont move anywhere. Do you have a solution to move that text to my target file