Data Validation on several sheets

[fpt264]

I have a workbook with seven identical sheets, each one containing entries for a different account. On each sheet in the range J3:J14 I use data validation.

Currently if I add an item to the validation list I have to go through each sheet individually and edit the list.

I would like to know how to create a "master list" where I could edit the list and have it apply to all of the sheets.

[JohnTopley]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[kvsrinivasamurthy]

Pl see file. Create dynamic range name ValList. List is in D column of Sheet1.
Formula

=OFFSET($D$1,0,0,COUNTA($D$1:$D$1000))

Use ValList name for data validation in all sheets. If elements are added or deleted in column D ValList automatically adjusted and drop down list shows all elements.

For Validation

List --> ValList