Microsoft improved the MS office features in every version. Sometimes people would like to pick the excel workbook column value from another sheet. for example, if they prepared the task planning in responsible person column, should be selected from the predefined person list. This will help easy to fill the data. How can we pick the data from another sheet?

Pick the Excel list data from another sheet

Microsoft Excel has this feature to pick the list value from another sheet. following steps guide you to pick the data from another list

  1. Open your excel workbook and create the one more sheet
  2. Then enter all values
  3. Now move to your Task plan sheet and select the responsible person column
  4. Then go to Data Tab and select the data validation under Data Tools section
  5. pick-list-value-from-another-excel-sheet-01

  6. In the data validation window select the validation criteria Allow as List and Select the source button
  7. Then move to list value sheet and select your data and click OK to save the settings
  8. pick-list-value-from-another-excel-sheet

  9. Now the responsible column values picked from the other sheet what you have configured
  10. pick-list-value-from-another-excel-sheet-03

In future, if you would like to add the more value then you have to add the data validation in the more rows.


If you liked this article, please subscribe to our YouTube channel for Technology videos.
The following two tabs change content below.
Jey Ganesh is a Tech Blogger of, Here you can find Technology, Internet and Mobile solutions. You can also engage with techThagavel via RSS, Newsletter. Email:

Comment :


reallly very awesome post very helpfull