I am not very experienced with excel so need help to do thefollowing:
I have column headers in columns A:G In the row below I have blankcells for data input. When column g has text input, I want a macro toautomatically copy the row (sans data but keep formulas and formatting) and paste in the row below.
For exampleif data is entered in G3, macro should copy row 3, insert and paste in row 4,delete contents of copied data in row 4. This sequence should repeat each timedata is entered in any cell in column G. The very last row has formulas tocalculate totals.
|Office||Date OT |
|Title||Last Name||First Name||Number of Hours||Justification |
|when data is entered here,|
macro copies this row and pastes below this row
|Total Hours |