ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   LINK ONE CELL TO AN ENTIRE LIST (https://www.excelbanter.com/excel-programming/374789-link-one-cell-entire-list.html)

thaenn

LINK ONE CELL TO AN ENTIRE LIST
 
In one cell for a worksheet, I would like to pick from an entire "list of
codes" in another worksheet and have that tied into a separate price for each
code.
(Trying to put togehter a Summary Sheet)

Can this be accomplished?

JNW

LINK ONE CELL TO AN ENTIRE LIST
 
1-Name the range that you want as the drop down list.
2-Then use data validation to create an in-cell drop down list (Data
Validation)
--
JNW


"thaenn" wrote:

In one cell for a worksheet, I would like to pick from an entire "list of
codes" in another worksheet and have that tied into a separate price for each
code.
(Trying to put togehter a Summary Sheet)

Can this be accomplished?



All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com