Required Macros to compare the value and need to take unique value and write in another column

[dineshkummar]

I have two Excel sheets with named :

Patching_MainSheet and ESL_Inventory

In Patching_MainSheet D column have 100 Servernames and ESL_Inventory Sheet A Column have 1845 Servernames and also I column have DataCentre name.
I need Macros to take one servername from Patching_MainSheet of D column and need to compare with 1845 Servernames in A Columns of ESL_Inventory Sheet if it matches, then it have to take one particular value(DataCentre Name) which is present I columns in ESL_Inventory and write down in B column of Patching_MainSheet.
Anyone guide me to prepare macros for this..

Thanks DK

 

[dineshkummar]

Looks like there is a slight typo, try it like

    For i = LBound(v2) To UBound(v2)
        If dic.exists(v2(i, 1)) Then

After I changed the script of those two lines and when I run i dont see anything running just simply nothing is happening.. Can I get your email id so that i can share the sheet privately so that you can check ?

 

[Fluff]

In that case you'll have to wait for mumps to come back online.

 

[dineshkummar]

looks like he will come online tomorrow only, is it possible you to check the sheet ?

 

[Fluff]

I'm sure mumps will be back before tomorrow.

 

[mumps]

@Fluff
Thanks for picking up on that.

I tested the macro using the data you posted and it worked properly. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet (de-sensitized if necessary).

 

[dineshkummar]

how to write down in B column of Patching_MainSheet. ? macros is writing in A column..

 

[dineshkummar]

I have changed to B column, macros is working as expected. Thank you so much for the help and support

@mumps and @Fluff​

 

[mumps]

Glad we could help.

 

[dineshkummar]

I need another help apart ESL_Inventory from I column, need to get data's from B,D and O has check and copy in E,I and J of Patching_MainSheet,

how we do that ?

 

[dineshkummar]

@Fluff : Any help on this :​

I need another help apart ESL_Inventory from I column, need to get data's from B,D and O has check and copy in E,I and J of Patching_MainSheet,

how we do that ?