Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Desktop file sharing
I am a complete idiot .. ummm... novice... when using Excel. Anyhow, I
have created a virtual "white board" in Excel showing which jobs are being worked on by whom, and the idea is that when a draftsman picks up a job, he edits the sheet to show that he has the job so that when clients are looking for it, they can access the same sheet and see who has it. I created the fields using macros, including a button for the draftsmen to click when the job is done. The problem is that I want to put this file somewhere local so that everyone in the office has access to it. If I put it on peoples' desktops, is there a way for the file to automatically update when it is changed by draftsmen as they complete jobs? If I bury it in the network nobody will use it. I could also save it as an html file, but I haven't figured out how to make that file editable except for the little "done" button. Any advice from you Excel wizards out there would be appreciated. Thanks, Liesl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FILE SHARING | Excel Worksheet Functions | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
how do i create a short cut on my desktop for a excell file? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
File Sharing Problems - Error Message | Excel Discussion (Misc queries) |