I'm doing a project where I need to insert hundreds of defined names
into Excel. I have the names and the info that goes into the "refers
to" box listed in a table. At the moment I'm laboriously copying and
pasting them into the "Define Name" dialog box one at a time.

Is there a faster way to do this? Is there some functionality in
Excel (or a third party tool) that allows many defined names to be
dumped into Excel at once? This would save me lots of hours.