Hi all,

So my VBA skills aren't great and this has me stumped...

I have 2 sheets, one called 'Plan' that tracks project work with columns that contain lists and formulae that I want to keep consistent. The other is called 'Template' and contains an unpopulated version of the populated columns in the Plan sheet but with the lists and formulae in.

I am after a macro that will copy the unpopulated 'Template' row formulae, lists and all and paste it into the 'Plan' sheet. However, I want to be able to specify how many rows to paste and at what row number location.

I am guessing this will require a lookup to a numeric value in 2 different cells so the macro knows how many rows to paste and at what row number location.

I tried to attach an example of what I'm referring to but I could not, instead I have stored the example in google docs here:

https://docs.google.com/spreadsheets...gid=1456821257

Please let me know if any further information is required.

Really appreciate any help on this!

Cheers,

Chris