+ Reply to Thread
Results 1 to 11 of 11

Pull Data to another sheet based on Criteria

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Pull Data to another sheet based on Criteria

    Hello All,
    I have attached a sample worksheet . I will have 15 worksheets inside a workbook ( 12 sheets for each month ) another separate 3 sheets. I have a sheet called "Receivables". I want that particular sheet to auto populate data from the remaining worksheets. It should pull data only from the rows which have "Debtors" and "Debtors Received" . Every time i run the macro it should clear the existing receivables sheet (Except Headers). and repopulate it . Hope i was clear enough. Thanks for trying to help me out.
    Attached Files Attached Files
    Last edited by Haree; 02-05-2022 at 04:15 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Pull Data to another sheet based on Criteria

    Hello Haree,

    See if this helps:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Pull Data to another sheet based on Criteria

    So Debtors value goes to Credit Column & Debtors Received value goes to Debit Column

    Please Login or Register  to view this content.
    Last edited by sintek; 02-05-2022 at 08:06 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  4. #4
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Re: Pull Data to another sheet based on Criteria

    Thank You so much for your time sir. It worked sir . Just a small help Debtors received value should go to Debit Amount. Would be very helpfull if you could help me in that

  5. #5
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Re: Pull Data to another sheet based on Criteria

    Quote Originally Posted by sintek View Post
    So Debtors value goes to Credit Column & Debtors Received value goes to Debit Column

    Please Login or Register  to view this content.


    Thank you so much sir. It worked perfectly fine. Very kind of you to have helped me in this regard. Thanks

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Pull Data to another sheet based on Criteria

    Glad I could assist...tx for rep +

  7. #7
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Pull Data to another sheet based on Criteria

    Hello Haree,

    I've just received notification of your reply but I see that Sintek has sorted out your query. So, for what it's worth, here is my amended code:-

    Please Login or Register  to view this content.
    Cheerio,
    vcoolio.

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Pull Data to another sheet based on Criteria

    As I love options...Here's another making use of filter...
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Re: Pull Data to another sheet based on Criteria

    Thank you sir for your time. I really appreciate your help

  10. #10
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    11

    Re: Pull Data to another sheet based on Criteria

    Thank you so much for this option sir. You were of great help. I could not thank you enough for your time.

  11. #11
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Pull Data to another sheet based on Criteria

    You're welcome Haree. Thanks for the rep.

    Cheerio,
    vcoolio.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA : Pull Data From Multiple Sheet Into 1 Sheet Based On Criteria
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2022, 11:58 PM
  2. [SOLVED] Pull data from another sheet based in criteria
    By shreyansgoyal in forum Excel General
    Replies: 2
    Last Post: 03-30-2015, 02:46 AM
  3. [SOLVED] Pull data from one sheet to another based on multiple criteria
    By thestalkycop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 01:38 AM
  4. Pull ranked data from another sheet based on one cells criteria
    By murphyjeff08 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-19-2013, 11:51 AM
  5. Replies: 5
    Last Post: 07-23-2013, 01:17 PM
  6. Pull data from one sheet to another based on criteria
    By lowrymike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2013, 12:53 PM
  7. [SOLVED] Pull data from another sheet based on certain criteria
    By steve_sr2 in forum Excel General
    Replies: 1
    Last Post: 02-23-2006, 06:15 AM

Tags for this Thread

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