I have one excel file. In file two sheets one is population & second is complaint.
In population sheet : I have data of customer code, engine no, customer name, city, district & date of installation.
In complaint sheet : I required ...
In A column : auto genrated no. If today date is 08 feb 2010 & complant no. 2. Then required auto genrate complaint no. required like : 08022010/02 First two digit date, third & forth is month & fifth,sixth,seven,eight digit is year after / no of complaint in particular date if complaint no.2.
In B column : Customer code.
In population sheet no of customers. More than 2000 customers list. Now I required if I / we press A then required all customer list which is start from A name. But here I want those customer code. Seleting by arrow / cusor.
I have attach sample file for your ready reference.
In D column
In population sheet (e column) esn_srno. One customer having 10 to 12 machine or more than also. I want only those engines of owner (BCDEFG customer name in column c2 or their code i.e A0128)
Bookmarks