I'm currently creating a template that will differ based on the users requirement. The next piece of the puzzle is to get it to copy a range of cells x number of times based on the number of buildings required. I then require the macro to copy data to populate some of those newly created cells.
I've attached an example of what I'm working with along with a bit more guidance. If you have any queries just give me a shout.
Thanks in advance,