Forum Discussion
Macros- Auto Copy paste row when cell value changes
I am not very experienced with excel so need help to do the following: I have column headers in columns A:G In the row below I have blank cells for data input. When column g has text input, I want a m...
Hello Hema12 ,
what is the big picture here? What are you trying to achieve with copy and pasting the rows? Do you need to duplicate formulas and formatting? If so, that can be done without VBA. Select the headers and the first row of data and use the command Insert > Table. With a table, ever row that is added below the last row will automatically have formulas and formatting applied.