Transfer Input Data from Sheet 1 to Sheet 2 on button click

**Daniel Pilgrim** · 07-10-2019, 02:53 AM

I'm in the process of setting up a very basic userform which I've created on sheet 1 of my workbook. The userform automatically populates the date with todays date then there are dropdown boxes for the user to select their name and the task they are performing. There are also 2 buttons to record the time they start a task and the time they finish a task. The data is held in cells D2, D4, D6, D8 & D11. What I'd like to happen is when the user selects the "Submit" button it transfers all the data to the next free row in corresponding columns on sheet 3 (i.e. D2 to next free cell of column A on sheet 3, D4 to next free cell of column B on sheet 3 D6 to next free cell of column C on sheet 3 and so on and so forth). I've found VBA solutions to transferring whole rows to the next free row in another sheet and solution to transferring data held in the same column where the cells are next to each other but can't find anything where the data is not in cells that are next to each other. Any support with this would be appreciated. Thanks

**AliGW** · 07-10-2019, 03:07 AM

Welcome to the forum.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.