Highlight and distribute

Hi friends,
I am trying to make an excel file to basically highlight the file name in sheet1 among a data set if any name matches in sheet 2, using a code
Then distribute the highlighted files in a separate sheet and all the files in another sheet, using another code.

I have tried to explain my problem using a dummy sheet and data. I was wondering if somebody could help me out.
Please suggest me if there is something better way could be done than the current method I am doing.
I have used 5 group as an example, this group can vary like 6 or 7 or may be more.
best regards,
me.

I am trying to make an excel file to basically highlight the file name in sheet1 among a data set if any name matches in sheet 2, using a code. Then distribute the highlighted files in a separate sheet and all the files in another sheet, using another code.

"Cutting" has three columns: File, Precision, & Date
"Category" has a list of File names.

Any file names in both "cutting" and "category" should be highlighted in "cutting."
And these items should be added to "level 1" and "level 2"
"Level 1" has file name and date.
"Level 2" has file name and precision.

Whey do the level sheets have multiple columns but only two fields? Normally a worksheet should only have the number of columns in which it has fields. For example, level 1 has file name and data. It would make sense that it should only have two columns. But you have ten columns, five sets of repeating fields. Unless you have a very good reason for doing it this way, it could cause all sorts of problems later on.

In level 2 in your after sheet, there are more items than were marked as highlighted. So does this mean that you want all the items from cutting moved into level 2?

In the cutting sheet, you have two buttons: Highlight and Distribute. What do you want these buttons to do?

Hi Steven,
Thanks for your reply. I am trying to explain my process for your help.
First when I click the Highlight button, I want the file names that are present in Category sheet to compare with Cutting sheet and highlight the matched file names in Cutting Sheet, which is present in Column A,
For example :
In Category Sheet there is : "Star Case 1.0.2"

In Cutting Sheet there are : Five "Star Case 1.0.2" in Column A in different rows, I want all the "Star Case 1.0.2" to be highlighted and so on.

This will enable me to sort out and prioritize the file in cutting sheet.

This is my primary requirement, I can at least start my work.I can manually filter the highlight and distribute the files. Once this is done Distribution is secondary. However I am explaining it also.

Then when i click the Distribute button, I simply want to distribute all the files present in Cutting sheet.
Now there are two sheets. Level I & Level II.

In Level I I want to distribute the highlighted files only and I will keep a track or repository of these files for future use.So next day when I again insert fresh data in Cutting sheet and highlight the priority file as per category sheet and distribute the highlighted files the files are distributed below the previous entries.
---> This level I sheet is not a important as I can simply filter the colored cells and distribute manually in Level I sheet.

In Level II I want to distribute the other files which are basically not highlighted.I don't want to keep a track of these files on next day. So I will simply clear the previous distribution.
So I was wondering if the code asks for how many sections you want to distribute the data and I select 4 or 5 or 10 , and the files are distributed accordingly, it will be great. As the distribution section may vary.
It will be a great help if these files are distributed on average of "Precision"

For example :
There are 6 files in Column A of sheet cutting which are not highlighted.
They are as follows :

File Precision
Tom 10
Cat 5
Mat 10
Nul Cat 2
Dul Cat 2
Cute Cat 1

So when I hit the distribute button, it will ask for how many sections : so I input 3 then the data will be distributed in 3 sections
Section 1
Tom 10

Section 2
Mat 10

Section 3
Cat 5
Nul Cat 2
Dul Cat 2
Cute Cat 1

So the files are distributed on more of less average Precision in 3 sections with 10 in each. I don't know if this could at all be done with Programming In that case can you please help me to distribute the file name only? I will do the rest manually.
Thanks a ton.
Best regards, me

See: fatalcore_Book1.xlsm

Hi Steven,
I couldn't find anything in the file...Am I missing something. Please guide.
The code section also looks empty.

Sorry about that. I guess when I closed the workbook, I forgot to save it (and thus lost everything).

See: fatalcore_Book1_v2.xlsm

And click on buttons.

Cross my fingers, this should work. :-)