+ Reply to Thread
Results 1 to 1 of 1

Trouble Ticket system - shared workbook updates

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Trouble Ticket system - shared workbook updates


    I created trouble ticket system in Excel 2003 and that will be used as a shared workbook by a bunch of people.
    Basically the users can fill and submit a form and the info goes into another sheet where the admins can see and delete tickets.
    (The bad thing is that I can only use Excel 2003. No Access or web server can be used )

    The problem that I see is to refresh the data for the admins. The user will save the workbook when clicking on ‘submit’ but I need the admins to have an up to date version before changing the file. I will run into conflicts if not.

    How can I solve that? How can I refresh the sheet with a macro before I change the file? Is there a better way to do this? Like with 3 different workbooks, a user interface, a admin interface and a data workbook?

    Thanks for the help!
    Last edited by gombi; 03-14-2012 at 04:33 PM. Reason: I opened a new question

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1