Excel Template Wizard - any good?

MIMF

New Member
Joined
Apr 4, 2002
Messages
16
Has anyone used the Excel Template Wizard that automatically adds records to a database file?
Do combo boxes and the information stored in them work as part of this process?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Where I work, we have used the Template Wizard for many useful applications. We have a template used by everyone in our department(30+ people)to record activities charged to overhead and transmit this to a database for our boss to review and write his reports from. We have used it to take surveys from employees state wide (500+) and tabulate data. We have also used it with ourmanagers to tabulate performance ratings for employees to a central database for HR to utilize. It can be a very handy tool when you need to collect information from many users or when you are inputing the same data over and over. Of course, each user must have access to the drive where the database file is stored.
 
Upvote 0
Our users are all connected on a MS Exchange network. Presumably the database file could be stored so that all users could submit entries using the Excel Template Wizard?
 
Upvote 0
I'm not sure how MS Exchange works. Basically, you need a shared drive where an Excel File can be stored that all users have access to open and edit.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top