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?
 
excel-tips

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.

 

The following two tabs change content below.
Jey Ganesh is a Tech Blogger of techthagaval.com, Here you can find Technology, Internet and Mobile solutions. You can also engage with techThagavel via RSS, Newsletter. Email: admin@techthagaval.com

Comment :

sunny

reallly very awesome post very helpfull

(reply)