help with a submit button

[cptcrash]

Hi all

Can someone please help me with a macro to make a submit button on sheet 1 take info form a row of cells, say a1,b1,c1,d1 and add it to a list on sheet 2
then clear the info from sheet 1 ready for new input.
when the button is pressed again it takes the new info from the same cells on sheet 1 and adds it to sheet 2 below the last line forming a list of info on sheet 2.

hope that makes scene

Im also very new to coding in excel so please explain how it works so i can modify it as needed.

Many thanks for any help.

[Olly]

Try:

Please Login or Register  to view this content.

Simple enough - it cuts range A1:D1 from Sheet1 and pastes to the next unused row in Sheet2.

Change sheet names to suit - note the references are to worksheet codenames.

[cptcrash]

Thanks for the fast reply i have added that code to a command button and entered info into a1 to d1 but when i hit the button nothing happens and the info in the cells stays there sheet 2 is still blank

[Olly]

What are your worksheet codenames?

[cptcrash]

just working with a fresh work sheet to get it working then i will add it to my sheet so sheets are called the default names (sheet1,sheet2 ect)

[Olly]

OK. Attach your workbook then, let's see what's going on

[cptcrash]

test sheet.xlsm

ok think its attached

[Olly]

You need to put the code in the Button Click event. Your code looks like this:

Please Login or Register  to view this content.

It needs to look like this:

Please Login or Register  to view this content.

[cptcrash]

Got it many thanks
now to make this start inputing to a set row ie list starts at row a3 down do i just add a row number after the Sheet2 bit?

[cptcrash]

Ok this works but...
Is there a way to have this cut the row without removing and formulas as the info is gathered from various cells over sheet 1 so i have set a row on sheet 2 to put all the data in to order in a line e.g
on sheet 2 A34=Sheet1 B2 B34=Sheet1 J6 C34=Sheet!1 C5 ect
I have set the code to cut Sheet!2 A34:F34 and put it onto sheet!3 on the next free line
Just need it to leave the = reference in place ready for the next input of data.
Thanks.

[Olly]

Changing it to something like:

Please Login or Register  to view this content.

This copies, rather than cutting; and pastes values.

Sorry, I didn't follow your "sheet 2 A34=Sheet1 B2 B34=Sheet1 J6 C34=Sheet!1 C5 ect" stuff; I'm sure you figure out how to combine what I've shown you with the exact references you need.

[cptcrash]

perfect your a star thanks