There are options in the Metadata Edit dropdown menu to Copy and Paste metadata from one book to another, there are also keyboard shortcuts you can customise, I have them set to Ctrl+C and Ctrl+V. And there's a Tweak to control which columns gets copied, search for 'exclude'.
BR
|