Excel: Adding a New Record to Database with a Macro

ID: Q52127

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0

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 :