Excel: Adding a New Record to Database with a Macro

ID: Q52127


The information in this article applies to:


SUMMARY

To add a new record to an existing Microsoft Excel database, you can incorporate or use the following macro:


   =SET.NAME("new.record",OFFSET(INDEX(!database,ROWS(!database),0),1,0))
   =SELECT(new.record)
   =INSERT(2)
   =SELECT(!database:new.record)
   =SET.DATABASE()
   =SELECT(INDEX(new.record,1)) 


A complete database and macro program using these commands is located on the Excel version 2.20 Help & Examples Disk at the following paths:


   Sampler Files:Tracking:Accounts Data (database file)
   Sampler Files:Tracking:Accounts Macros (macro sheet) 


NOTE: You can also add a record to an existing database by choosing Form from the Data menu and clicking New.

Additional query words: checkbook


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 15, 1999