Hi All,
Firstly thank you for taking the time to view my query.
I have a named range in Template Sheet, which is 9 cells on a row containing formulas. I wish to use vba to copy this row and paste this on another sheet, either AAA, or BBB (which are copies of each other, but will vary over time regarding the different projects undertaken). I hope to paste them always beginning on column A, but in terms of row position I wish for them to be pasted under the last populated row (in case of sheet AAA row 28, sheet BBB row 21). Is there a way that this can be done?
Apologies for screenshots, I am unable to successfully install xl2bb
Thanks in advance.
Firstly thank you for taking the time to view my query.
I have a named range in Template Sheet, which is 9 cells on a row containing formulas. I wish to use vba to copy this row and paste this on another sheet, either AAA, or BBB (which are copies of each other, but will vary over time regarding the different projects undertaken). I hope to paste them always beginning on column A, but in terms of row position I wish for them to be pasted under the last populated row (in case of sheet AAA row 28, sheet BBB row 21). Is there a way that this can be done?
Apologies for screenshots, I am unable to successfully install xl2bb
Thanks in advance.
