I have multiple sheets (~20 sheets) as shown in picture 1. Previously I fill the details in the table manually one by one. But I realize I could save a lot of time by doing data validation. Only problem is I already filled half of the sheet numbers, and have half more to go. Picture 2 is the data validation source that I created. Is there any way to apply the data validation only to the selected cells all at once? because all the sheets are pretty much the same table, just with different sheet name.
Bookmarks