Macro to add, delete and edit data to a table

[skf786]

Hi,

im looking for a macro that can help me add, delete and edit data available in a table.

Input cells are A1:C1 (Reference number, customer name and phone number) and table starts from A5:c5 (has headers) and goes down as more data is added to it.

Add Data: User inputs data in cell a1:c1 and presses a Button 1 that adds the data at the last row in the table and returns to blank cell A1:C1.

Delete Data: User inputs reference number in cell a2 and presses a Button 2 that searches the reference number in the table and deletes the full row i.e. a to c and returns to blank cell A2.

Edit Data: User inputs reference number in cell a3 and inputs revised data in b3 and c3 and presses a Button 3 that searches the reference number in the table and replaces the full row with the new data (from a3:c3) and returns to blank cell A3:c3.

Many thanks for your help.

Best wishes,

skf

 

[Alex Blakenburg]

If you have no experience with macros you might want to give this a try.
You can still have a button that invoked the Data Entry Form.