PDA

View Full Version : Adding Records to an Excel table Vba



chichaspowa
11-06-2010, 11:25 AM
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
11-06-2010, 12:02 PM
Off the top



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

chichaspowa
11-06-2010, 06:07 PM
thx james :)