Create A Form With Password Protected Data
I want to create a simple form for employees to enter their number of hours worked for the day. Driver name, Start Time, Finish Time and date. I need this information to populate an excel spreadsheet but I don't want the employees to be able to view the data that is being put in. Also possibly throw an error if the same employee accidentally enters their information twice.
Re: Create A Form With Password Protected Data
how about using a web form for them to input hours to ?
Input Hours -> https://docs.google.com/forms/d/1hvp...w91Us/viewform
Sheet that displays results -> https://docs.google.com/spreadsheets...gid=1959723821
Excel can import the data through a web connection, can be auto-refreshing, or refreshed manually
If you think this could work for you, it would just need some code to go through the data collected, like if you have a list of employees get it to check that a response has been received by all for dates required.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By KEAnderson in forum Excel Programming / VBA / Macros
Last Post: 05-19-2014, 10:02 PM
By bkrose120 in forum Excel Programming / VBA / Macros
Last Post: 08-26-2013, 03:24 AM
By jeck in forum Excel Programming / VBA / Macros
Last Post: 05-03-2011, 11:04 AM
By Joy C in forum Excel General
Last Post: 03-25-2011, 05:46 AM
By robindemey in forum Excel Programming / VBA / Macros
Last Post: 03-05-2010, 02:53 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1