How JustAnswer Works:
  • Ask an Expert
    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: 36526
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

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

This answer was rated:

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.
Thank you for your question, my name is Richard.

So you want Excel to apply the colors that are listed in your Access Data base.

Is this correct?

Customer: replied 3 years ago.

Yes, that is correct, if possible

ok, not 100% clear

Tell me how you expect the process to work for the user please
Customer: replied 3 years ago.

Can you provide a link so I can upload the Excel workbook, to explain/show what I am looking for?

Of course.

- Click the following link:
- 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"

Customer: replied 3 years ago.

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?


Is that any clearer, or did I make it muddier?

That clarified it.

But no, you will not be able to automate this.

But then, why not make the form itself within Access?

Richard and other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.

"But then, why not make the form itself within Access?"

I consider myself very average on the capabilities of Excel, and very below average on Access. What I have been able to creat within access has been very crude, but functional.


thank you though for the response.

Your most welcome, but what you are trying to achieve, looks better suited within Access.

Excel is more for data analysis, not data entry.

But I can understand based on your current knowledge.

Though, if you have a go at it in Access, you have me here for assistance :)

Richard and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions