I would like to make a bill summary in excel where the column consists Vendor Name, Product Name, Category, User, Company of user , Company Address ect.
What is want is that when i will write the product name it will automatically display the category of that product to corresponding cell based on a table where it will be mentioned that which product belongs to what category or which user belongs to which company, Similarly when i will write the user name it display the company name and address in corresponding cell of Company Name/Address.
Bookmarks