Hi there,
I'm hoping that someone can send me VBA code to insert lines in a file. I have a cell A4 that tells me how many customers I'm missing (with a formula). I want it to insert the number of rows after the last cell with a value column C based on this formula. e.g. the value is 4 and C75 is the last cell in that column with a value so I would want it to insert 4 rows after row 75. Additionally since the last row is row 75 I want to also copy cells B75 to I75 down 4 rows.
To summarize -
1)Insert number of rows after the last row that has a value in column C based on a formula in Cell A4
2) Copy the cells in that last row from column B to column I down the same number or rows.
Thanks so much
I'm hoping that someone can send me VBA code to insert lines in a file. I have a cell A4 that tells me how many customers I'm missing (with a formula). I want it to insert the number of rows after the last cell with a value column C based on this formula. e.g. the value is 4 and C75 is the last cell in that column with a value so I would want it to insert 4 rows after row 75. Additionally since the last row is row 75 I want to also copy cells B75 to I75 down 4 rows.
To summarize -
1)Insert number of rows after the last row that has a value in column C based on a formula in Cell A4
2) Copy the cells in that last row from column B to column I down the same number or rows.
Thanks so much