Adding Records to an Excel table Vba

[chichaspowa]

Hello everyone,

Id like some help on something probably easy for u guys.

I have a 2 sheets, one named "clients" and another named "InsertClient".

On "insert client" i have a cell (A1) and a button that says insert.

What i would like the button to do is, when the user inputs a name into A1 i want the button to go to my "clients" sheet where i have a table(column A and B) and find the next blank row on column B and insert the name i had on cell A1.

Can someone help me on the code i can insert on the button.

Thx

[Bob Phillips]

Off the top

[vba]

Worksheets("Sheet2").Range("A1").Copy Worksheets("Sheet1").Range("B1").End(xlDown).Offset(1, 0)
[/vba]

[chichaspowa]

thx james