Search for similar cells in column and set corresponding value

[Avantime]

Hi all,

I have a list of codes in column A, I fill columns B,C,D with "x", depending on the situation.
I need a program that finds similar codes in column a and fills in the corresponding cell like in the attached image so I don`t have to search previous inputs to set the same value.

I do not want to use formulas because they take a lot of time to calculate, I have 9000+ codes to search through.

Thank you!

[Decar]

you would have to specify "similar codes" and maybe an example excel sheets with some made up codes. The problem is that "similar" might be both codes have an x in them or they should have at least 5 digits which should be the same. Thos scenarios are very different and will yield different results.

[Avantime]

Thanks for the quick reply.

Sorry for me being ambiguous in the first post. I meant I needed a script to find the exact code duplicate and fill in the corresponding cell, either B or C or D or E with the corresponding value. So the script needs to find other codes like the already marked ones and complete accordingly.
There isn`t really much else to say.

I attached a sample workbook.

[Decar]

Have a look but many codes don't have exact copies of your previously marked x's and in your marked ones are duplicates.

[Avantime]

I really appreciate your efforts!

Let me explain more clearly.
I have the product codes in column A. Columns B/C/D/E represent locations for that code. For example B is central warehouse, C is regional warehouse, D is small warehouse and E is all warehouses.
As I complete locations in the file, I want the script to automatically complete below any occurences of the same code with the same location so I don`t have to do the same work a lot of times.

Is it clear?

Thank you!

[Avantime]

*Duplicate*

[Decar]

so lets take the test sheet I uploaded. You want to plug in codes in the little table to the right for a,b etc. and then the code will check each code if it is the same as in one of the codes you specified there.


VBA has to somehow know that code N4965017 is all warehouses or small or regional. There must be a reference where vba will look where to put the x

[Avantime]

I set where the product will be located manually. If there is nothing set on a specific code VBA has nothing to set on other occurances.
For example if for the first code (N4963029) I place an x on the same row and under C column, I need all other occurances below of the same code to have an x on the same column.

[Decar]

that sounds quite complicated. The only way I could think of helping you with this is to create a new list next to where each code is. In this list each code will be included only once and there you will have to choose the warehouse for each code. If a code is not marked it will not be assigned.

[Avantime]

No, every code has multiple applications, hence the multiple occurrences..

[Decar]

I'm a bit confused. I meant that you specify for each code in which warehouses it belongs in a separate table. According to this separate table the main table will be updated and there might be that code (N4963029) is in 0, central and regional or all warehouses together.

But if you want code (N4963029) to be in warehouse central in the beginning and in between in warehouse regiona + central then there is no logic VBA can build upon to automate the process.

[Avantime]

Two occurrences of the same code will not have different locations. I don`t want to copy the code in a separate table.

[Decar]

I think I get what you want now ^^. The table for the unique codes would be generated automatically. Maybe I have some more time later then I will try to help you more