pulling data from a cell number

%3CLINGO-SUB%20id%3D%22lingo-sub-2261066%22%20slang%3D%22en-US%22%3Epulling%20data%20from%20a%20cell%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3Ehi%2C%20i%20am%20looking%20for%20some%20help%20in%20excel.%20i%20have%20a%20table%20and%20in%20this%20table%20it%20confirms%20which%20of%20our%20advisers%20has%20a%20form%20for%20a%20client%20and%20which%20don't%20have%20a%20form.%20i%20want%20to%20know%20if%20there%20is%20a%20way%20for%20me%20to%20click%20on%20the%20number%20that%20doesn't%20have%20the%20form%20and%20this%20will%20bring%20up%20the%20list%20of%20clients%20without.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ethis%20way%20it'll%20essential%20create%20a%20hit%20list%20of%20clients%20to%20get%20a%20form%20filled%20out.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261066%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

hi, i am looking for some help in excel. i have a table and in this table it confirms which of our advisers has a form for a client and which don't have a form. i want to know if there is a way for me to click on the number that doesn't have the form and this will bring up the list of clients without.

this way it'll essential create a hit list of clients to get a form filled out.

1 Reply
I'm quite sure that what you're looking for is readily accomplished. However, your description has enough ambiguity in it--the structure of the table itself, for example, is not clear--that I hesitate to suggest a solution.

Is it possible for you to change all the names, so no confidential information is released, and post a copy. If it's a huge table with many, many names, at least a sample of what the columns are and a reasonable facsimile of it, again with fake names.