In Excel, I am looking to copy every 3 rows and columns A:K for each row after a certain value for every 24 rows. For example, in A1 the word "example" is listed then I need A2:K4 copied, A6:K8 copied, A10:K12 copied and so on until the next time the word "example" shows up in column A. The word "example" is usually every 24 rows. Is there a way to do this with a formula or would I need to create a macro?
Thanks