Enter data using forms

[nc]

Is there a internet link of an example of a macro for
entering multiple rows data when pressing a save/new
button once?

Thanks.

 

[Dave Peterson]

If there is, I bet it would be difficult to find.

But if you want a workbook that starts off with certain data already in it, you
may want to consider creating a template -- and saving it into your template
folder.

Then when you do file|new, you can point at that template and you'll have that
predefined data already there.

As for the save, you could use a worksheet event that adds your data.

If you give more information, I'm sure someone will jump in with some
assistance.