Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2016
    Thanked 0 Times in 0 Posts

    VBA Code to pull out the data from another sheet basis on multiple criteria's

    Hello Everyone,

    I need to pull out the data in Column D of "Sheet1" basis on criteria's in Column A, B & C from "Sheet2" multiple worksheets. I have tried Index Indirect Function which is working fine but the "Sheet2" is closed & Indirect function won't work on closed workbook.

    Can anyone please help me out with the vba code. I am scratching my head from the morning but not been able to resolve it. I am attaching the sheets for your reference please. Hope I am able to explain clearly.

    Many Thanks in Advance.

    Best Regards,
    Attached Files Attached Files
    Last edited by abhi_jain80; 2016-08-08 at 03:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts