Macro to insert a variable number of rows into a variable location

[TheClaw2323]

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

[Leith Ross]

Hello TheClaw2323,

You should have made the file public and not required permission for access.

If your workbook contains sensitive or confidential information, please change or redact that information before you post.

[TheClaw2323]

Hi Leith,

Apologies, you should be able to access it via the link below. The data has been redacted.

https://docs.google.com/spreadsheets...it?usp=sharing

[Leith Ross]

Hello Chris,

You almost got lost in emails. Over the past few days I have gotten over 200. Takes me awhile to check them all.

Thanks for posting the shared version. I am still not clear about what you are doing. Can you provide an examples (before and after) of the data and formulae?

[TheClaw2323]

Hi Leith,

Well thanks for following up

I have managed to attach the file now with the macro I already have in place.

The macro currently inserts new 'template' lines into the plan sheet at row 9. I basically just want to see if there's a way to specify how many of these 'template' lines to insert and at what specific row number without having to change the macro code itself.

I'm thinking it will require a lookup to 2 different cells, one with the number of rows to insert and one with the row number location to insert the cells at, although I don't have the VBA skills to know if this is possible.

I hope that clears it up a bit? Please let me know if not.

Cheers,

ChrisExcel Example.xlsx