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? |
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