+ Reply to Thread
Results 1 to 2 of 2

I am looking to add a template to my excel file, dependent on what is in a cell

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003 / 2007
    Posts
    14

    I am looking to add a template to my excel file, dependent on what is in a cell

    I am looking to add a template to my excel file, dependent on what is selected in a cell from a drop down box.

    Basically, I order a lot of food for people from 3 different outlets and instead of them emailing it to me and then having to create each order separately, I wanted to simplify the process and allow them to place their own orders.

    For example:

    Cell A1, would contain a VLOOKUP to a master resource list, so they can select there name from a drop down.

    Cell A2, would contain a drop down with either Indian, Chinese, or Pizza as the selection choice.

    Dependent, on what was selected in A2, an order template would be shown under these cells.

    They would then create their order and click a "submit" button, which would then transfer the data to an order spreadsheet containing 3 tabs, Indian, Chinese, or Pizza.

    I have attached a sample pizza order template, I was just looking for some assistance as to whether this is an easy task to complete?Order Template.xlsx

  2. #2
    Registered User
    Join Date
    03-18-2013
    Location
    Stryków, Poland
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    21

    Re: I am looking to add a template to my excel file, dependent on what is in a cell

    Create hidden sheet with template of the order and use Worksheet_Change event, to copy formats after dropdown change.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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