Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a sheet with 2 columns: various different names and a…

Customer Question
I have a sheet with...
I have a sheet with 2 columns: various different names and a column with 1 of 6 different IDs. I want to create a Data Validation on another page that lists ONLY the names of each of the 6 different IDs in the dropdown. How can this be best accomplished? Thank you.
Submitted: 2 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 4 minutes by:
2/1/2016
Programmer: Jason Jones, Programmer replied 2 years ago
Jason Jones
Jason Jones, Programmer
Category: Programming
Satisfied Customers: 19,460
Experience: Over 10 years of work experience.
Verified

Hello,

I am the person that will be helping you today. May I take a look at the document you need help with so that I can complete this task for you?

Please, be forewarned that the site is not secure:
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
I will be standing by.

Thank you,
Jason

Ask Your Own Programming Question
Customer reply replied 2 years ago
I have attached the sample file here. Can you work with this? Thanks.
Programmer: Jason Jones, Programmer replied 2 years ago

Thank you. I will start working on this.

Ask Your Own Programming Question
Customer reply replied 2 years ago
I clicked the button for a call but don't really need this. If you can insert the proper formulas into the sample file and email me back, that would be sufficient. Thanks.
Programmer: Jason Jones, Programmer replied 2 years ago

Thank you for the update.

Ask Your Own Programming Question
Programmer: Jason Jones, Programmer replied 2 years ago

I am looking at the sheet now. Please, explain what you need for this document to do.

Ask Your Own Programming Question
Customer reply replied 2 years ago
I'm logging off now. Will you email me tomorrow?
Customer reply replied 2 years ago
I want to create a Data Validation on the second page that lists ONLY the names of each of the 6 different IDs listed, in the dropdown. See the file for info.
Programmer: Jason Jones, Programmer replied 2 years ago

I honestly, do not understand. You wish to choose one of the values in the dropdown box and have the resulting items that match, be entered into the 2nd sheet?

Ask Your Own Programming Question
Customer reply replied 2 years ago
On the second page (Sheet1), in cell A6, I want a dropdown list of all the names in column B on the Manager Info tab where column A (AllocationAproach) is the letter C. Then in cell B6 on Sheet1, I want a dropdown list of all the names in column B on the Manager Info tab where column A (AllocationAproach) is the letter COMB. Etc. Etc. Ok?
Programmer: Jason Jones, Programmer replied 2 years ago

I got it. Thank you for the clarification. I will have this fixed and uploaded soon.

Ask Your Own Programming Question
Programmer: Jason Jones, Programmer replied 2 years ago

Do you need a macro of some sort to be setup for this or do you just need me to gather the values as you described and create the sheet for you?

Ask Your Own Programming Question
Customer reply replied 2 years ago
Ideally, I just want the formula in cell B6. If this requires some other interim formulas, put them on the file too. Thanks.
Programmer: Jason Jones, Programmer replied 2 years ago

You wish to have this done in A6 to G6, correct?

Ask Your Own Programming Question
Programmer: Jason Jones, Programmer replied 2 years ago

I have run out of ideas.

For this reason, I am opting out of the question and allowing another expert the chance to help.

The next expert will see all that is on this page, so there will be no need to repeat anything.

When another expert picks this up, you will be notified by email.

Thank you for your patience.

- Jason

Ask Your Own Programming Question
Programmer: The-PC-Guy, Software Engineer replied 2 years ago
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,215
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript
Verified

hello, I will be helping you with this.

Just so I understand you want to have multiple drop downs, one that lists the values for each of the unique values in column A. Is this correct?

Also I will need to know which version of excel you are running

Thanks

Ask Your Own Programming Question
Customer reply replied 2 years ago
On the second page (Sheet1) of the attached sample file, in cell A6, I want a dropdown list of all the names in column B on the Manager Info tab where column A (AllocationAproach) is the letter C. Then in cell B6 on Sheet1, I want a dropdown list of all the names in column B on the Manager Info tab where column A (AllocationAproach) is the letter COMB. Etc. Etc. Ok?
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

can you tell me which version of excel you are using?

Ask Your Own Programming Question
Customer reply replied 2 years ago
Excel 2013
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

ok, then a macro will work.

You should understand the following.

1. There is no formula that will do this. The way data validation lists work is by using a range of cells with values.

2. A macro can be used to sort and filter this data into several lists and then create the drop downs for you.

3. The macro can be put in so that every time you open the workbook it runs for you and updates the lists incase you add more data. or a button can be added that you push

to update the data.

4. There will be an additional fee to create such a macro.

Does this sound agreeable?

Ask Your Own Programming Question
Customer reply replied 2 years ago
Are you saying there is no formula that can look at an entire list and only look for the letter C (like a VLOOKUP or something) and then return a list of all the names that meet that condition? What would the macro do? Sort the list, create a NAME that would then be assigned to the Data Validation?
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

a vlookup would not work as it would only give you the first value that matches.

So the macro would create separate lists for all the values matching each letter. Instead of only the first result that vlookup would do. The macro could also create the data validation lists themselves from those lists.

Think of it like having a bucket with different colored golf balls in it. THe macro would separate all of the red balls into a list, and all of the blue ones, and green ones, and so on.

Ask Your Own Programming Question
Customer reply replied 2 years ago
Take a look at this newest sample file. On the Manager Info page, I've added columns that list all the Nicknames that are assigned to each allocation. Now the question is, how to build a DataValidation that eliminates the blank rows when creating the dropdown.
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

unfortunately you are going to have the same problem. You will still need a macro to filter out the blanks.

You can sort all the columns By descending values before doing the lists, but some lists will still have blanks in the middle.

This was listed as a programming question. I suggest you strongly consider the macro, it will make things easier in the long run

Ask Your Own Programming Question
Customer reply replied 2 years ago
But I saw a website last night on how to create a column, next to each column, that would eliminate the blanks. Then you could set the DataValidation to be off this column that has no blanks. There were no macros involved. Just a formula that eliminates the blanks. Are you aware of how to implement this?
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

sorry, a formula willl not get rid of the blanks.

Not sure what you saw on some website, but there is a lot out there that is incorrect. As I said the formula would only return the first result, not all of them.

It is possible to eliminate the blanks by sorting the column, in essence putting all of the blanks at the bottom.

Ask Your Own Programming Question
Customer reply replied 2 years ago
What about this:http://www.mrexcel.com/forum/excel-questions/635269-remove-blanks-data-validation-drop-down-list-condition.html
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

do you have something about macros. Again much easier.

Ask Your Own Programming Question
Customer reply replied 2 years ago
It's just that I'm giving this to a person that is not that Excel literate and am concerned about HIM executing the macros. I'm not that familiar with a macro but isn't that just an automation of some keystrokes that I would do to filter properly?
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

sorry, a macro is so much more. It can actually program any function that you could do manually. Like copying and pasting all of the values into separate columns and generating drop downs from that.

I just don't see a formula working in this case.

The only thing with a macro is they don't run on MAC os. And some security settings in excel make it so you have to press a button at the top of the screen to enable macros when you open the document. Other than that the macro would be programmed to run when the workbook is opened. So other than enabling macros the person you give it to would not have to do anything else.

You asked for my expertise and I have been working with excel for over 20 years and know all the ins and outs. I do sometimes feel that macros will work in some circumstances where formulas will not.

Ask Your Own Programming Question
Customer reply replied 2 years ago
Will I be able to see the steps that you include in the macro?
Programmer: The-PC-Guy, Software Engineer replied 2 years ago

you can view the code for the macro, but I am not sure you will understand it. Just know that the macro can do what you were looking for.

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 2,215
2,215 Satisfied Customers
Experience: Extensive Knowledge in PHP, MYSQL, CSS & Javascript

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

2,215 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I am on the hunt for a digital solution to a currently
Hi Pearl! I am on the hunt for a digital solution to a currently manual problem. :) … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,215 satisfied customers
I'm trying to develop a tool team which assists with overall
I'm trying to develop a tool for our team which assists with overall project and task management. Each team member has a sheet within an excel doc which they are responsible for updating on a weekly b… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,215 satisfied customers
I have a spreadsheet and I've been using Data Validation for
I have a spreadsheet and I've been using Data Validation for a drop down list on many of the cells. When I wanted to expand the list I redefined the name and all of the sudden I am getting the message… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,215 satisfied customers
What macro code can I use to copy and paste data from one sheet
What macro code can I use to copy and paste data from one sheet into another while linking that data to a dynamic list validation?… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
2,215 satisfied customers
Is it possible to create VB code to allow a dropdown box with
Is it possible to create VB code to allow a dropdown box with data validation to have autocomplete functionality? If yes, then can you write it?… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
HiI was wondering whether it is possible to see different
Hi I was wondering whether it is possible to see different data depending on the name that is selected in a Data Validation list that I have. At the moment, I have different manager's names in the Dat… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel/VB question. I have a data validation cell set up so
Excel/VB question. I have a data validation cell set up so that when a selection is made from the drop-down list a picture corresponding with the selection appears in a designated location. I have bee… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi John! Its been a while since I asked you a question.
Hi John! It's been a while since I asked you a question. How are you? I have a another excel related question: I have a spreadsheet where I have to add in multi select drop downs in cells for various … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
GreetiingsI am trying to separate data in individual cells
Greetiings I am trying to separate data in individual cells to multiple columns. I have a list of names and addresses that are all in individual cells, and each cell needs to have the info separated o… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am using XL 2010 and I have a dropdown target list consisting
I am using XL 2010 and I have a dropdown target list consisting of approx. 12 names on a separate worksheet called” Lists” that I use to insert a list of names into the same cell of a single column, u… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel question I need the formulas to solve the following
Excel question I need the formulas to solve the following problem: 1) I want to transfer data from one spreadsheet to another. 2) The data spreadsheet (spreadsheet 2) will cover two columns, where the… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Need to know if MS Access 2007 can help me do the following....I
Need to know if MS Access 2007 can help me do the following....I have have three different excel spreadsheets that I need to upload into a single data base. Once they have been uploaded only some of t… read more
Eljon
Eljon
Software Developer Consultant
Associate Degree
562 satisfied customers
I need 50 of my employees (who are not office based) to input
I need 50 of my employees (who are not office based) to input daily data into an excel document which is on sharepoint. My worry is that anyone who wishes to be disruptive can fiddle with their collea… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
For John D You made a sort Macro for me. What I want
For John D You made a sort Macro for me. What I want to do is to be able to create is a summary page that looks back to the detailed information and pulls up totals based on a specified (by the user) … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
When i create a new spreadsheet in excel, it has some sort
When i create a new spreadsheet in excel, it has some sort of formula in it that when I put something in one sheet, it automatically transfers it to another sheet. I have created new documents on thre… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working in Excel. I have one sheet with 15 columns of
I am working in Excel. I have one sheet with 15 columns of data and the first column is an ID number. I have another similar worksheet with the 15 columns of data and the first column contains ID numb… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have just done a multiple retail store physical inventory.
I have just done a multiple retail store physical inventory. I need to total the Qty differences from a key field (SKU #/ ALU) from 5 different sheets in MS Office Excel 2007. Would you help me accomp… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am a painting contractor and am trying to creat a job costing
I am a painting contractor and am trying to creat a job costing sheet that enable a user to select a name from a dropdown list which when selected will put the hourly cost of that employee in the cell… read more
Dutch Kim
Dutch Kim
Post-Doctoral Degree
44 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x