Hello all,

I've run into an issue working on a small project. I hope you can help!

The project:

A workbook in which sheet 1 is a form for people to input into 2 adjacent columns time spent on different tasks at the end of each work week. Sheet 2 is identical to sheet 1, but has the intended purpose of storing the data input into the form in sheet 1.

There is a button at the bottom of the form in sheet 1 with an assigned macro that effectively transfers all the data to sheet 2 and then clears sheet 1 for another entry.

The issue:

I cannot get the data to transfer to the next available set of 2 adjacent columns in sheet 2. It keeps repopulating the first 2 columns.

Any help on modifying the macro to transfer data to the next available set of 2 columns on sheet 2 would be much appreciated.

Thanks!