Andreas Hermle
asked on
Copy range into clipboard and paste it above rows with bold cell entries
Dear Experts:
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.
Regards, Andreas
Inserting-Headers-Before-Rows-Co.xlsm
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.
Regards, Andreas
Inserting-Headers-Before-Rows-Co.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great! Works like a charm.
Thank you very much for your swift and professional help.
Regards, Andreas