VBA to replicate a range of cells based on the number of buildings required

Morning all,

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,

Snook

Another option

Please Login or Register  to view this content.

Thanks both, they worked a treat.

Something else that I would like to incorporate is placing borders around the cells that contains the building information.

I've managed to pull the following code together which works but I'd be interested to know if there was a more efficient way of achieving this?

Please Login or Register  to view this content.

Thanks,

Snook

I wouldm't say that this was any more efficient, but simply another way of writing it

Please Login or Register  to view this content.

That looks a lot cleaner, cheers.

Your welcome