Forum Discussion
Excel
Hi Ila1972,
you can use a combination of the Data Validation and AutoFill features in Excel.
Create a table with the following columns:
- Name
- First name
- Date of birth
- Account number
- Email address
Enter the data for the first row of the table.
In the Name column, select the cell that contains the first name.
On the Data tab, click the Data Validation button.
In the Data Validation dialog box, click the List tab.
In the Allow list, select List from a range of cells.
In the Source box, enter the range of cells that contains the names you want to use.
Click OK.
Now, when you select the cell that contains the name, a drop-down list will appear. You can select a name from the list, and the rest of the columns will be automatically populated with the corresponding data.
To use the AutoFill feature, select the entire first row of the table and drag the fill handle down to the last row of the table.
The rest of the rows will be automatically filled in with the corresponding data.
Some additional notes:
- You can use the Data Validation feature to create a drop-down list of any type of data, such as numbers, dates, or text.
- You can use the AutoFill feature to fill in a range of cells with the same data.
- You can use the Conditional Formatting feature to highlight cells that contain specific data.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
- Ila1972Sep 26, 2023Copper ContributorOk many thanks, I try and come back to say it's ok or not ...