VBA Macro. Need help on finding the value and paste after split the digits

[it04mani]

Looking for a macro to perform the below mentioned actions.

Book1 has 4 columns. Acode, TID, XID, Process ID.
Book2 has 3 columns. B code, Replace, TID

Need to replace the values in Book 1 based on XID. XID and BCODE are similar if we consider the last 8 digits. Once we split last 8 digits then find the value of "Replace" column and Replace the value in Book 1 "XID". Also need to replace "TID" from Book2 to Book1 based on XID.

So please support me on VBA macro to split and consider the last 8 digits and replace XID with BCODE and TID with TID from Book2 to Book1. You can see multiple XIDs in Book 1 so it has to be replaced with the value of BCODE.

 

[charlesdh]

Hi,
I was looking at your request. But, I do not follow nor understand it.
I do not see the correlation between the work books. You mention the last 8 digits. But, I do not see the last 8 digit between the workbooks.