I would like to copy and paste a selected range as follows:
This range (B2:G2) on the active worksheet is selected manually.
The macro is to copy the selection into the clipboard and paste it
above each row that has bold cell entries.
I have attached a sample file with detailed explanations for your convenience.
Help is much appreciated. Thank you very much in advance.