Send specific cells to another tab using VBA

[D3njy]

Hi all, I'm struggling with VBA and what is probably a simple task.

I have a worksheet used for marking, the information input in 'Marking' needs to be sent to another 'Data' tab by clicking a submit button.

After submit is clicked I'd like the 'Marking' sheet to clear and, when used again, input new data on the next line.

 

[D3njy]

Hi all, I'm struggling with VBA and what is probably a simple task.

I have a worksheet used for marking, the information input in 'Marking' needs to be sent to another 'Data' tab by clicking a submit button.

After submit is clicked I'd like the 'Marking' sheet to clear and, when used again, input new data on the next line.

This is the basis of what I've been looking at but I need to move individual cells.

Input Form to Get Data and Store it in Another Tab in Excel - TeachExcel.com

How to make a user input form in Excel and have the data stored on another worksheet at the click of a button This method uses a simple to create input form that anyone can make and maintain within th ...

www.teachexcel.com