[01] - open macros of the list of vbaproject

[02] - Info steps

[03] - Sub WB_50_Menu_Maker() - click and run

[04] - ------------------------------------------------------------------------------------------------

[05] - Look on Sheet9 - column F should be selected - right-click and copy

[06] - Goto - zzzz_goto_Ref - Should be open

[07] - Now scroll - goto to the "stop here"

[08] - Right above the "stop here" - go up to the Emd Sub

[09] - Now Select all the data above and starting with End Sut to the top of page

[10] - Just Select End Sub - Then use the button to the right and scroll to top

[11] - Now using "shift-key" click mouse just left of the Sub WB_menu_1 everything should be selectd

[12] - Hit backspace or Delete - Now Right-click and click Paste

[13] - ------------------------------------------------------------------------------------------------

[14] - Now go back to Sheet9 - and on "WB_50_ListMacros_zzzz"

[15] - Next:

[16] - Now on the macro that opened

[17] - Click by the beginning of "Sub WB_50_ListMacros_zzzz()"

[18] - Hit Run or the Arrow - give it time to finish the process

[19] - ------------------------------------------------------------------------------------------------

[20] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[21] - Now right-click on the selected column B - and select copy

[22] - ------------------------------------------------------------------------------------------------

[23] - Now - Goto - zzzz_goto_Ref - on the macro screen

[24] - Next:

[25] - Now Scroll down a little and select the top "Sub zzzzz_goto_"

[26] - Now Scroll down to bottom and Hit the "shift key" click right at at the end of "End Sub"

[27] - Should all be Selected - backspace or hit delete

[28] - ------------------------------------------------------------------------------------------------

[29] - Now in macro screen - at the top - Click "Debug" - click "Compile_VbaProject"

[30] - Now it might give error - on the blue highlighted click the end - just put a 2 at end

[31] - Now in macro screen - at the top - Click "Debug" click "Compile_VbaProject"

[32] - This is double checking - just repeat the process if needed

[33] - ------------------------------------------------------------------------------------------------

[34] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[35] - Click on "WB_50_Del" button - and look up a little should see the numbers disappear

[36] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[37] - Click on "WB_50_Open" button - and look up a little should see the numbers reappear

[38] - ------------------------------------------------------------------------------------------------

[39] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[40] - Now - at the bottom of screen - Right-click on Sheet at left of Sheet1 - and select delete - say-yes at the bottom of screen -

[41] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[42] - Now click on "ListMacros_Make_Hyperlink" - let process finish

[43] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

[44] - Now Click near the left and top of screen - Click on "DupB"

[45] - Now in macro screen - at the top - Click to the left - "Sub Duplicates_sbFindDuplicatesInColumnB_leave_cell_blank"

[46] - Now click "Run run or the arrow"

[47] - And Select Cell "C1" - Now - holding down the - Control-key & shift-key - arrow down

[48] - Should see a duplicate - no bigggg-e

[49] - Now at the bottom left of Main screen Right-Click on the 2 files left of "Sheet1" and delete both

[50] - Should be complete - unless - haha