Microsoft KB Archive/52127

{|
 * width="100%"|

Excel: Adding a New Record to Database with a Macro

 * }

-

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(&quot;new.record&quot;,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 :

Technology :