Results 1 to 3 of 3

Thread: make a template

  1. #1

    make a template



    Register for a FREE account, and/
    or Log in to avoid these ads!

    trying to figure out how to make a template for the attached file.
    want to make the customer details to be fillable as the file.
    want to be able to use drop box of products or just be able to fill in with the colums in a template.
    can someone please tell me how to make this happen.
    thanks in advance.
    Attached Files Attached Files

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Sorry don't understand most of what you want.

    trying to figure out how to make a template for the attached file.
    Save as template (xla)

    want to make the customer details to be fillable as the file.
    ???

    want to be able to use drop box of products
    Copy products to a new sheet (preferably hide this sheet). Create named ranges Prod_Desc and Prod_Item
    On sheet1 Description, use data validation, List "=Prod_Desc"
    On Item use "=if(b8="","",index(Prod_desc,match(b8,Prod_item))"


    or just be able to fill in with the colums in a template.
    ???

  3. #3

    sample

    Quote Originally Posted by WizzardOfOz View Post
    Sorry don't understand most of what you want.

    trying to figure out how to make a template for the attached file.
    Save as template (xla)

    want to make the customer details to be fillable as the file.
    ???

    want to be able to use drop box of products
    Copy products to a new sheet (preferably hide this sheet). Create named ranges Prod_Desc and Prod_Item
    On sheet1 Description, use data validation, List "=Prod_Desc"
    On Item use "=if(b8="","",index(Prod_desc,match(b8,Prod_item))"


    or just be able to fill in with the colums in a template.
    ???
    can you put them into the attached file? i cannot seem to get it to work for me
    ty

Posting Permissions

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