+ Reply to Thread
Results 1 to 2 of 2

Fillable forms that auto-update a master file

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Kelowna, Canada
    MS-Off Ver
    Office 2010
    Posts
    30

    Fillable forms that auto-update a master file

    I am wondering if it is possible with Excel to have a fillable form that, when submitted, would update as a new record on a master file? For example, lets say I have three columns (Name, Category, Sub-Category). Using a weblink or similar access, a person would be able to click for a new submitted record that would allow them to fill out the three categories (category and sub-category from a dependent drop down list format) and then click a button that says "Save" or "Submit." That form would then be sent to an email address where that person could approve or reject the new submission. If approved, the new submission would be added to a list of previously submitted records on a master Excel file. If rejected, the form would be returned to the sender's email for editing and re-submission. Is this possible?

  2. #2
    Registered User
    Join Date
    08-22-2014
    Location
    Kelowna, Canada
    MS-Off Ver
    Office 2010
    Posts
    30

    Re: Fillable forms that auto-update a master file

    Anybody with any ideas/suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to update Master inventory file using links to individual item forms
    By jfleisher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2014, 11:38 AM
  2. Replies: 0
    Last Post: 03-04-2013, 03:40 AM
  3. Auto update Master File from the Data entry File.
    By Saintjp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 05:19 PM
  4. Auto update Master File from the Data entry File.
    By Saintjp in forum Excel General
    Replies: 1
    Last Post: 02-07-2013, 05:51 PM
  5. Replies: 0
    Last Post: 05-04-2012, 10:43 PM

Bookmarks

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