How JustAnswer Works:

Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site.Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist

Category: Microsoft Office

Satisfied Customers: 21053

Experience: Over 15 year experience resolving Microsoft Office Issues

32989067

Type Your Microsoft Office Question Here...

Richard is online now

Richard, is it possible to use a list of materials contained

Resolved Question:

Richard, is it possible to use a list of materials contained in an Access 2007 table, as the list of options on an Excel 2007 cell? Example I have a list of paint colors (in Access), and would like to use that list as the options for an excel 2007 cell.

I have uploaded file ID 926644, which is the Excel workbook, I have also uploaded a screen shot of the list within the Access Database (file ID 419984).

When looking at the excel worksheet, on the left side, there are several labels, I am specifically working with cell G50, the label to the left of that cell says "Frame Color". I currently am using a list of cells, with a data validation tool to create the list, but due to the inventory always changing, I would prefer to use the updated list within the Access database. We update the list within the database, daily, and so if I added a new color within the database, I would have to go in and change the data validation within excel, as well, and see that as being very time sensitive.

So currently the user clicks the G50 cell, and the drop down arrow appears with the partial list I have inserted in the cells. If possible, instead of the data coming from within the cells, when the user clicks the G50 cell, it is pulling the data from the access database instead?

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

Ask a Microsoft Office Technician

Get a Professional Answer. 100% Satisfaction Guaranteed.

59 Microsoft Office Technicians are Online Now

Type Your Microsoft Office Question Here...

characters left:

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.