Question How to write a macro to display only grouped items in Excel

[aj81]

Here is the issue. I'd like to use a macro to display only those items which stay as a group in "Old Project Code" (black font) and filter out those which are singles in "Old Project Code" (red font) as shown below extracted out from a worksheet called "Project" in Excel.

J K
New_Project_Code Old_Project_Code
62409 AU028
62410 SAU029
62411 ZZZ001
62963 ZZZ010
62964 ZZZ010
62965 ZZZ010
62966 ZZZ010
62967 ZZZ010
62412 ZZZ050
62973 ZZZ061
62974 ZZZ061
62975 ZZZ061

Bear in mind:
1. The color wasn't there in original sheet. It is here only for demo purpose.
2. Data are changing dynamically, so need a macro in place to catch a snapshot at the time of macro is firing.

I know this is Access forum and the issue is an Excel issue. Because I am a member of this site I'd like to give it a try in this forum to see anyone familiar with Excel VBA. Thanks guys.

NB. J K are columns
New_Project_Code Old_Project_Code are column headers

 

[EternalMyrtle]

Will the numbers in black always start with 629 and the ones in red 624?