make a template

hatman

New member
Joined
Sep 13, 2014
Messages
2
Reaction score
0
Points
0
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.
 

Attachments

  • Family Drug.xls
    47 KB · Views: 11
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.
???
 
sample

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
 
Back
Top