Spreadsheet: 99505d1298121256-obtain-selective-data-from-different-worksheet-activity-1a
Sheet: Summary

DATE | 2011-01-01 00:00:00 |  | <<< B2 is a dropdown list box with source obtained from another worksheet.
ID | NAME | ISSUE | FREQ | DATE | NUM | LOAN | TYPE | TERM | RATE | Balance | [NAME] | Arrears | Stage
179065 | [NAME] | 1 | W | 2008-11-29 00:00:00 | 461 | 600 | CL | 57 | 18 | 446 | 109 | 446 | 9 |  | BALANCE EXTRACTED FROM ROW 10 - COLLECTIONS WORKSHEET
294274 | Freda [NAME] | 1 | M | 2010-09-11 00:00:00 | 487 | 200 | CL | 31 | 10 | 150 | 16 | 10 | 0 |  | BALANCE EXTRACTED FROM ROW 13 - COLLECTIONS WORKSHEET
453293 | Master Chef | 1 | W | 2009-01-10 00:00:00 | 919 | 600 | CL | 57 | 18 | 766 | 103 | 766 | 10 |  | BALANCE EXTRACTED FROM ROW 21 - COLLECTIONS WORKSHEET
701488 | [NAME] | 1 | M | 2010-09-04 00:00:00 | 746 | 1000 | CL | 50 | 35 | 1280 | 17 | 160 | 7 |  | BALANCE EXTRACTED FROM ROW 26 - COLLECTIONS WORKSHEET
810564 | [NAME] | 1 | W | 2010-10-02 00:00:00 | 791 | 150 | CL | 31 | 7.5 | 142.5 | 13 | 15 | 2 |  | BALANCE EXTRACTED FROM ROW 31 - COLLECTIONS WORKSHEET
810564 | [NAME] | 2 | W | 2010-12-04 00:00:00 | 403 | 200 | CL | 50 | 7 | 327.5 | 4 | 12.5 | 2 |  | BALANCE EXTRACTED FROM ROW 32 - COLLECTIONS WORKSHEET
810571 | Chromium Plate | 1 | W | 2010-10-02 00:00:00 | 746 | 150 | CL | 31 | 7.5 | 142.5 | 13 | 15 | 2 |  | BALANCE EXTRACTED FROM ROW 37 - COLLECTIONS WORKSHEET
810571 | Chromium Plate | 2 | W | 2010-12-04 00:00:00 | 395 | 200 | CL | 50 | 7 | 327.5 | 4 | 12.5 | 2 |  | BALANCE EXTRACTED FROM ROW 38 - COLLECTIONS WORKSHEET
879240 | Heather Softee | 1 | W | 2010-09-25 00:00:00 | 118 | 700 | CL | 50 | 24.5 | 785 | 14 | -72.5 | 0 |  | BALANCE EXTRACTED FROM ROW 46 - COLLECTIONS WORKSHEET
879240 | Heather Softee | 2 | W | 2011-01-01 00:00:00 | 96 | 500 | CL | 60 | 15 | 900 | 0 | 15 | 0 |  | BALANCE EXTRACTED FROM ROW 47 - COLLECTIONS WORKSHEET
NOTES:
Column A = Active list sourced from Column B in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column B = Can be filled using an existing formula in conjunction with the "Clients" Worksheet or using a NAME range.
Column C = Optional column to possibly assist with the number of times that an ID has a positive balance at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column D = Can be filled using an existing  formula in conjunction with another Worksheet in the main workbook.
Column E = Active list sourced from Column D in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column F = Active list sourced from Column E in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column G = Can be filled using an existing  formula as shown in conjunction with another Worksheet in the main workbook.
Column H = Can be filled using an existing  formula as shown in conjunction with another Worksheet in the main workbook.
Column I = Can be filled using an existing  formula as shown in conjunction with another Worksheet in the main workbook.
Column J = Can be filled using an existing  formula as shown in conjunction with another Worksheet in the main workbook.
Column K = Active list sourced from Columns Q or W in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2.
Column L = Active list sourced from Columns L or R in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column L = Active list sourced from Columns P or V in the "Collections" Worksheet where there is a positive BALANCE at the date shown in B2 i.e. Columns Q & W in the "Collections" worksheet.
Column N = Can be filled using an existing formula in conjunction with [NAME] in the main workbook.