+ Reply to Thread
Results 1 to 7 of 7

Auto genrated no & view list of customer & machine number

  1. #1
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Auto genrated no & view list of customer & machine number

    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)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: Auto genrated no & view list of customer & machine number

    In all honesty this really does sound/look like an Access job.

    You'll be able to store the data a lot better and run querys to find out all the required information.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Auto genrated no & view list of customer & machine number

    I m not familier of Access or VBA.

    Can u help on this matter. Thanks.

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Auto genrated no & view list of customer & machine number

    can u guide me.
    Last edited by avk; 02-11-2010 at 04:41 PM. Reason: self

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Auto genrated no & view list of customer & machine number

    Bump no reply.

    if possible though vba program then please confirm process or program.

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Auto genrated no & view list of customer & machine number

    avk, I think JJ's answer says it all. Simply because you're not familiar with an application does not mean that it can be done with VBA. Why don't you spend some time getting familiar with Access. We also have an Access forum here, so please feel welcome to post Access questions there.

    regards

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Auto genrated no & view list of customer & machine number

    we have posted in access forum. thanks teylyn.

+ 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