I have attached two pictures of the spreadsheet to help make this clearer


I need to have a VBA macro that will do the following: go to H15 : H40 through V15 : V40 and insert the contents into the sheet starting at BB15:40. BC15 should contain the VALUE of Cell BB15. Cells BD15:BG15 simply separate the contents of BC15 into columns. This would be repeated for columns J-V and rows 15 to 40. I can do this all manually, but would like to have a macro to accomplish this task for me. Unfortunately, after much research and attempts I have failed to write it myself. Can you help?