+ Reply to Thread
Results 1 to 6 of 6

Compare a value with value in other sheets and then COPY data into a sheet.

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    580

    Compare a value with value in other sheets and then COPY data into a sheet.

    Dear Friends,

    I need a help to solve a problem.

    I have a worksheet in which I have customer data (currently active). The ANO field is the unique code for each customer.

    In other three sheets, QLY1, QLY2, QLY3 some sales stats (of customers) are there.

    Now, I need to cosolidate the customer data with QLY (all 1, 2, 3) statistics together in a CONSOLIDATED sheet.

    Besides, I need to count no.of QLYs in which the concerned ANOs appear.

    I have attached the sample file for your kind reference.

    Thanking you and in anticipation,

    acsishere.
    Attached Files Attached Files
    Last edited by VBA Noob; 02-26-2009 at 12:29 PM.

  2. #2
    Registered User
    Join Date
    06-12-2004
    Posts
    15

    Re: Compare a value with value in other sheets and then COPY data into a sheet.

    Use vlookup and isna. See attached
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-12-2004
    Posts
    15

    Re: Compare a value with value in other sheets and then COPY data into a sheet.

    Forgot the count. Now added
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    580

    Smile Re: Compare a value with value in other sheets and then COPY data into a sheet.

    Dear Sir,

    Thanks for your solution with application of formulas. It seems simple & good.

    But, as I have more than 150 columns/15,000 rows in each QLY file, I think it is a tedius job to copy in each & every column.

    Hence, I feel a VB code will be the better solution to do as it may not take more than a minute to do the process.

    Any help in VB?

    sincerely yours,
    acsishere.

  5. #5
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    580

    Smile Re: Compare a value with value in other sheets and then COPY data into a sheet.

    Dear Friends,

    Can anyone help me to find a solution through VB code?

    Please....

    sincerely yours,

    acsishere.

  6. #6
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    580

    Smile Re: Compare a value with value in other sheets and then COPY data into a sheet.

    Dear Friends,

    Any help? Please....

    acsishere.

+ 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