ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Lists (https://www.excelbanter.com/excel-discussion-misc-queries/173318-multiple-lists.html)

BillCPA

Multiple Lists
 
I have Worksheet 'A' that contains two different lists - List 'X' and List
'Y'. On Worksheet 'B', I have named these two lists from 'A' and use them
for validating data.

Is there a way to have one drop-down validation list on 'B' include the data
from both lists? Or do I have to combine 'X' and 'Y' into one list first?

--
Bill @ UAMS


All times are GMT +1. The time now is 02:35 PM.

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