Thanks JW.
Data list
1st list:
GL Date Batch Name Difference Status Responsible
1-Oct-07 ML-014-011007-49 $321.15 Warning David
1-Oct-07 ML-015-011007-50 $153.01 Warning David
1-Oct-07 ML-017-011007-52 $100.00 Warning David
1-Oct-07 ML-023-011007-58 $4.85 Warning David
4-Oct-07 1MLCLSAMEX100107 $2,336.30 Warning Betsy
4-Oct-07 2MLCLSAMEX100107 $206.40 Warning Betsy
2-Oct-07 ML-006-021007-32 $150.00 Warning Tally
2-Oct-07 ML-008-021007-34 $262.78 Warning Tally
2-Oct-07 ML-006-021007-6 $63.24 Warning David

2nd list:
Customer# GL Date On Account $ Days Old Responsible
13449170 10-OCT-07 $4,934.08 7 Jackie
12858370 14-DEC-06 $2,304.00 309 Jenni
222196855 26-SEP-07 $1,980.65 28 Jackie
702319450 12-DEC-06 $1,551.00 309 Jenni
252432972 28-JUL-07 $1,408.10 85 David
252350184 28-FEB-07 $1,167.07 232 Jackie
292526500 15-AUG-07 $1,085.65 63 David
43155965 05-SEP-07 $1,065.38 42 Julio
222199552 16-MAR-07 $983.12 217 David

And this is what it should look like
1st tab:
GL Date Batch Name Difference Status Responsible
1-Oct-07 ML-014-011007-49 $321.15 Warning David
1-Oct-07 ML-015-011007-50 $153.01 Warning David
1-Oct-07 ML-017-011007-52 $100.00 Warning David
1-Oct-07 ML-023-011007-58 $4.85 Warning David
2-Oct-07 ML-006-021007-6 $63.24 Warning David

Customer# GL Date On Account $ Days Old Responsible
252432972 28-JUL-07 $1,408.10 85 David
292526500 15-AUG-07 $1,085.65 63 David
222199552 16-MAR-07 $983.12 217 David

2nd tab:
GL Date Batch Name Difference Status Responsible
4-Oct-07 1MLCLSAMEX100107 $2,336.30 Warning Betsy
4-Oct-07 2MLCLSAMEX100107 $206.40 Warning Betsy

Customer# GL Date On Account $ Days Old Responsible
no data

tabs 3,4,5 ect.

Hope that make sence.

Thanks
"JW" wrote:

On Oct 16, 5:33 pm, pgarcia wrote:
Such theatrics,
Spread sheet with 5 tabs. The five tabs a equal to 5 employees. All the tabs
will be setup the same. Two list; 1st list) Show's invoice to be applied, 2nd
list) Shows what has been applied that are "on-account". Each list changes
daily, what I would like to do is the following:
Have two input tabs, 1) has the invoice data, 2) has the "on-account" data,
both have lists contains the person name. The name may appear several times
but the data will change daily. The list of names is based off the following
formula: =INDEX('Cash App Schedule'!$B$2:$Q$21,MATCH(B2,'Cash App
Schedule'!$A$2:$A$21,0),MATCH(D2,'Cash App Schedule'!$B$1:$Q$1,0))
I would like to populate two list on the tab with the invoice data and
"on-account" data.
I tried using Vlookup, but it was limited. It worked for the first tab,
first name, but the 2nd tab, 2nd name, it did not work properly. I had to
start at the end of the first name and as you can understand, the lists
change daily and will not have the same amount of entrees.
This is what I do now, for a list with this information, I filter the name
and cut and paste them in to the tab. I'm not able to use a Pivot table as I
know the employees will not know how to use it.

Thanks in advance, a loyal follower

Hi Paul. This one is difficult to understand without seeing a
"picture". Could you post an example of your data structure and an
example of the desired outcome?