Having issues with macro made to create list

%3CLINGO-SUB%20id%3D%22lingo-sub-1533731%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20issues%20with%20macro%20made%20to%20create%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266858%22%20target%3D%22_blank%22%3E%40Julius835%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20quickly%20take%20down%20this%20spreadsheet%20and%20replace%20it%20with%20one%20that%20has%20no%20real%20names%3F%20I'm%20going%20to%20give%20you%20a%20non-macro%20answer.%20I'll%20let%20someone%20else%20give%20you%20the%20macro%20answer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E....but%2C%20in%20the%20meantime%2C%20the%20rule%20around%20here%20is%20that%20real%20names%20of%20real%20people%20aren't%20to%20be%20included%20in%20sample%20sheets.%20So%20I've%20notified%20the%20board%20moderator%20and%20it%20will%20be%20taken%20down%20by%20them%20if%20you%20don't%20take%20care%20of%20it%20first.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533769%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20issues%20with%20macro%20made%20to%20create%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266858%22%20target%3D%22_blank%22%3E%40Julius835%3C%2FA%3E%26nbsp%3BHello!%20As%20per%20our%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fcommunity-guidelines%2Fmicrosoft-tech-community-code-of-conduct%2Fm-p%2F31390%22%20target%3D%22_self%22%3Ecode%20of%20conduct%3C%2FA%3E%2C%20please%20don't%20reveal%20personal%20or%20private%20information%20here%20in%20the%20Microsoft%20Tech%20Community.%20We've%20removed%20your%20attachment.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533785%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20issues%20with%20macro%20made%20to%20create%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533785%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266858%22%20target%3D%22_blank%22%3E%40Julius835%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20way%20to%20generate%20that%20list%20of%20names%20(or%20whatever%20you'd%20like)%20without%20macros.%20This%20does%20presume%20you%20have%20the%20most%20recent%20version%20of%20Excel%2C%20capable%20of%20handling%20the%20%3CSTRONG%3EFILTER%3C%2FSTRONG%3E%20function.%20I've%20converted%20your%20several%20tables%20into%20a%20single%2C%20differentiating%20departments%20from%20one%20another%20by%20an%20additional%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20populate%20the%20entire%20table%2C%20and%20then%20use%20the%20%22X%22%20to%20select%2C%20you'll%20see%20the%20list%20dynamically%20grow%20as%20you%20enter%20the%20letter%20%22x%22....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533684%22%20slang%3D%22en-US%22%3EHaving%20issues%20with%20macro%20made%20to%20create%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533684%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20macro%20made%20is%20supposed%20to%20allow%20you%20to%20place%20an%20'X'%20beside%20several%20names%20and%20after%20clicking%20the%20'Create%20List'%20button%20a%20list%20should%20be%20generated%20of%20those%20names.%20I'm%20not%20sure%20of%20the%20issue%20with%20the%20macro.%20Thank%20you%20for%20your%20help%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1533684%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533991%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20issues%20with%20macro%20made%20to%20create%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20about%20that%2C%20thank%20you%20for%20informing%20me!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

The macro made is supposed to allow you to place an 'X' beside several names and after clicking the 'Create List' button a list should be generated of those names. I'm not sure of the issue with the macro. Thank you for your help in advance.

4 Replies
Highlighted

@Julius835 

 

Could you quickly take down this spreadsheet and replace it with one that has no real names? I'm going to give you a non-macro answer. I'll let someone else give you the macro answer

 

....but, in the meantime, the rule around here is that real names of real people aren't to be included in sample sheets. So I've notified the board moderator and it will be taken down by them if you don't take care of it first.

Highlighted

@Julius835 Hello! As per our code of conduct, please don't reveal personal or private information here in the Microsoft Tech Community. We've removed your attachment. 

Highlighted

@Julius835 

 

Here's a way to generate that list of names (or whatever you'd like) without macros. This does presume you have the most recent version of Excel, capable of handling the FILTER function. I've converted your several tables into a single, differentiating departments from one another by an additional column.

 

If you populate the entire table, and then use the "X" to select, you'll see the list dynamically grow as you enter the letter "x"....

@mathetes 

Sorry about that, thank you for informing me!