|
|
#2
04-18-2025, 08:10 AM
|
||||
|
||||
In the attached file, I created a list in columns A and B. I then imported them to Power Query and merged them with a space separator. I then closed them to a table in column D. I then created a data validation in 1F for the values in Column D. I then added values to Column A and B. Clicked on Data Refresh All and the table in Column D is updated. The data validation is also updated in Column F.
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Validation | firozmohammed | Excel | 4 | 11-18-2023 01:55 AM |
 Copying and Concatenating data in excel based on a value in another column
|
BoardingSUP | Excel Programming | 5 | 10-17-2021 08:05 AM |
| Need to copy specific ranges column data as row data from one worksheet to another using excel VBA | ganesang | Excel Programming | 1 | 03-26-2020 06:18 AM |
|
Data Validation List based on Two Named Ranges
|
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
Windows 11 
Office 2021
Threaded Mode