I am trying to do some data entry which will use Excel. I'm hoping you can help me understand how to set up the system. I believe my inquiry is similar to, but not exactly like, the post at http://www.contextures.com/<wbr>xlDataVal11.html.
I have a sheet like
file_name | full_name
123 | Jane Doe
123 | John Public
456 | Sally Roe
456 | Steve Smith
and I want to manually enter another sheet like
file_name | full_name | new_column_1 | new_column_2
123 | Jane Doe | data1 | data2
123 | John Public | data3 | data4
456 | Sally Roe | data5 | data6
456 | Steve Smith | data7 | data8
but where the cell full_name in the latter table will offer autocomplete. Two considerations:
- I want to only offer autocomplete from among the names in the first sheet sharing the file_name value of the current row
- In some cases, It's possible that a name was accidentally skipped in the first pass of data entry, so I want to be able add a new name even if it doesn't match one of the suggested names for that file_name. For example, I want to be able to add
to the file in the second spreadsheet, even if Alexander Abrahmson does not appear in the first sheet.
The link above provides most of a solution using Validation, but I don't think it permits the two additional specifications I've added. Do you think it's possible to do this in Excel?
I have a sheet like
file_name | full_name
123 | Jane Doe
123 | John Public
456 | Sally Roe
456 | Steve Smith
and I want to manually enter another sheet like
file_name | full_name | new_column_1 | new_column_2
123 | Jane Doe | data1 | data2
123 | John Public | data3 | data4
456 | Sally Roe | data5 | data6
456 | Steve Smith | data7 | data8
but where the cell full_name in the latter table will offer autocomplete. Two considerations:
- I want to only offer autocomplete from among the names in the first sheet sharing the file_name value of the current row
- In some cases, It's possible that a name was accidentally skipped in the first pass of data entry, so I want to be able add a new name even if it doesn't match one of the suggested names for that file_name. For example, I want to be able to add
| 123 | Alexander Abrahmson | data9 | data10 |
to the file in the second spreadsheet, even if Alexander Abrahmson does not appear in the first sheet.
The link above provides most of a solution using Validation, but I don't think it permits the two additional specifications I've added. Do you think it's possible to do this in Excel?
