I have a spreadsheet named "Required Work". I want data to move from this sheet to another spreadsheet named "WIP" based on whether I enter any data into column G. The data entered into column G is going to be months but I would like it to move the data if any value is entered. I would like the information to be cut from the "Required Work" sheet and pasted into the next empty row in "WIP" sheet and I want the empty row in "Required Work" to be deleted.
All I am looking for is the code because I cannot figure this out. Any advice at all would be great! Thank you for your assistance I greatly appreciate it.