I have data in columns A6:AH6
There are many other details in the entire sheet, lets say a word "Summery" comes many times from column A10 onwards
Whereever there is the word "Summary" from column A10 onwards I want VBA to copy entire text from A6:AH6 and paste it above the word Summery
I already have already created an empty row above the word Summary so no text would be replaced.