standard data form direct to an excel spreadsheet
I want to be able to put in a persons name, address, postcode, social
security number etc in a row of an excel file. I must be able to do this over a network so many users can add to the spreadsheet. The program must also log the time that the data was added... any ideas on doing this? Scott |
standard data form direct to an excel spreadsheet
Scott,
with due respect, this is a job for a database, not a spreadsheet. If you are insistent on using a spreadsheet program like Excel then create a shared workbook and use a form to add data. Load the for from the Workbook_open event. OJ |
standard data form direct to an excel spreadsheet
You don't need a form, Excel has a built-in (DataForm...). All that is
needed is some event code to add the date when a line is changed. -- HTH RP (remove nothere from the email address if mailing direct) "OJ" wrote in message oups.com... Scott, with due respect, this is a job for a database, not a spreadsheet. If you are insistent on using a spreadsheet program like Excel then create a shared workbook and use a form to add data. Load the for from the Workbook_open event. OJ |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com