Hello,
Need help!!.. do we have a macros for :
I have two workbook - WB 1 and WB 2
I am looking to compare cells $A:$A from WB1 with cells $A:$A in WB2. Suppose the value in WB2 cell A6 matches with WB1 A1, I want the value from WB2 cell I6, J6, K6, L6 amd M6 copied over to WB1 cell Q1, R1, S1, T1 and U1 respectively. i.e.
WB2 I6 --> WB1 Q1,
WB2 J6 --> WB1 R1
WB2 K6 --> WB1 S1
WB2 L6 --> WB1 T3
WB2 M6 --> WB1 U1
At a clink of a button, I require that all cells from WB1 $A:$A should automatically compare the value in WB2 $A:$A, and if the value matches, update columns Q,R,S,T and U in WB1 with corrosponding value in column I, J, K, L and M in WB2.
I have 250 such cells in WB1 to compare with WB2 everyday.
I have attached a sample file.
I greatly appreciate your help!
Need help!!.. do we have a macros for :
I have two workbook - WB 1 and WB 2
I am looking to compare cells $A:$A from WB1 with cells $A:$A in WB2. Suppose the value in WB2 cell A6 matches with WB1 A1, I want the value from WB2 cell I6, J6, K6, L6 amd M6 copied over to WB1 cell Q1, R1, S1, T1 and U1 respectively. i.e.
WB2 I6 --> WB1 Q1,
WB2 J6 --> WB1 R1
WB2 K6 --> WB1 S1
WB2 L6 --> WB1 T3
WB2 M6 --> WB1 U1
At a clink of a button, I require that all cells from WB1 $A:$A should automatically compare the value in WB2 $A:$A, and if the value matches, update columns Q,R,S,T and U in WB1 with corrosponding value in column I, J, K, L and M in WB2.
I have 250 such cells in WB1 to compare with WB2 everyday.
I have attached a sample file.
I greatly appreciate your help!
Attachments
Last edited: