I have a spreadsheet with 1000 picklists for a report.

I would like to copy the input range from one Format Control - input range
to all the other picklists.

Is there any way to do this without opening every Format Control and copy
paste my input range into the field?

HELP!