Results 1 to 1 of 1
2016-08-05, 09:48 #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
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.
Last edited by abhi_jain80; 2016-08-08 at 03:46.