excel form data to excel data table within same workbook

[okeefedl99]

Please can someone guide me how to copy the data entered in an excel form into an existing table within the same workbook using a single command button but without having to step into the VB code. I have an idea I'm talking if, vlookup, index but not sure how to construct it.

Many many thanks in advance.

 

[SkipVought]

okee,

If you are using Data/Form then

1. fill in the textboxes

2. click [New]

this will transfer data from the Form to the table and clear the Form for the next operation.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884