How do I append data to an Excel workbook using a template?

S

Statman

I have created a data entry template in Excel, but don't know how to save it
and then add additional entries to the saved workbook. I don't have Access so
I can't use that.
 
R

R. Choate

I'm assuming you've already tried the Data>Form option from your menu and found it lacking what you need. If that is the case and
you want a form for data entry then you will have to use VBA and build a form. There are probably add-ins available that will do
this for you. Also, if you want a simpler solution that does not require a form, you can set up a data input area on the spreadsheet
but will still need VBA to deliver the input to new cells elsewhere on the WS.

HTH
--
RMC,CPA


I have created a data entry template in Excel, but don't know how to save it
and then add additional entries to the saved workbook. I don't have Access so
I can't use that.
 
S

Statman

Thanks for the info. Yes, Data>Form wasn't robust enough for my needs. Looks
like VB will have to be the answer. I suppose I'll need to read up on that.
Once again, thanks for your reply.

Mike
 
Top