what function copies data from an excel form to excel table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top