what function copies data from an excel form to excel table

[cerys]

Using an excel form to add new records, what is the best way to then add this data to an existing table within the same workbook

Thankyou for your hel

Cerys

 

[Debra Dalgleish]

One easy way to add data to an existing table is to use Excel's Data
Form. To use it, select a cell in the table, and choose Data>Form.

Another option is to use John Walkenbach's Enhanced Data Form. It's a
free add-in, allows combo boxes, and has unlimited fields.

http://j-walk.com/ss/dataform/index.htm