How to update range list in Data Validation cell, all at once?

[Flicker]

Hi, I have an Excel file that utilize Excel Data Validation - List by link to another sheet. However, the list seems not in the same pattern due to data were add up later in another sheet. so, the row at top part link to a number of rows while the bottom part link to data in more rows which added recently.

now I want the cell at top part be able to choose data that added recently, too. but I do not want to change the data, just the range of the validation list. Instead of copy one by one , are there any way to replace this all at once?

I mean if I want to replace data validation list in the all selected ranges area to A1:A100 all at once, could someone suggest me how to do that?

Thanks in advanced.

 

[Oaktree]

I think you just need $s.

If you select all of the cells you want to apply the validation to, then go to data --> data validation, then allow a list where the source is =$A$1:$A$100, does that get you what you're looking for?

 

[Flicker]

Hi Oaktree,
oh.. that's what I'm looking for. Thank you so much. (I felt so stupid that I tried to manually update one by one. XD)