Import a line of data and then produce a code based on 3 criteria - Read the whole sheet

Hello,

Recently I have started to learn VBA but it's still difficult for me to solve the following:

In an excel sheet (monthly orders), each user will import the following data:
Column A: Month/Year
Column B: Location (text)
Column C: Category (text)

Column D: Here I would like to create a unique code, as follows:
First, combine the columns A,B,C: "Location/Category/Month" and in the end
add a letter (with an alphabetical order) of the items that have been imported in the whole excel sheet for the specific month, location & category.
For example, the format of the unique code (col D) will be:
Loc1/Cat2/0721/B -> This was the second item for the month July, location1 & category2
Loc2/Cat2/0721/B -> This was the second item for the month July, location2 & category2

Your help will be much appreciated!
Thank you!

Hello, thank you so much for the quick reply and your help!

I run the macro and the results are as shown in the excel file I have attached.
Actually what I need is, every time that a user fills in the columns A,B & C, the macro should read the whole table, count how many items have already been imported for the specific month, location &category, give me the right letter in alphabetical order.
(The macro code should first read the month then the location and last is the category)

In column E, I wrote the right results for the unique code I need to produce.

Thank you in advance!!

Sure! I need to use the filters because there will be more than 30 items per month when the users will start importing their orders.

Try

Please Login or Register  to view this content.

Thank you very much both!! This definitely has helped me a lot.
Appreciated