Copy Row Automation
I have two separate sheets. On sheet 1 I would like to type in a date and then it would copy that row over to sheet 2. When doing this the data is populating down at the bottom of the sheet when the data ends in row 26 the copied row is getting pasted in row 131 or something like that.
Not sure why or what do to do fix this. Any suggestions?