G
Guest
I have worksheets with several names and their associated deposits in individual rows. Some of the names in each worksheet may be different some may be the same. eg
Worksheet A Worksheet B Worksheet C Consolidated Work Sheet (What I want
John 500.00 Jane 300.00 John 500.00 John 1100.0
Mary 200.00 Tom 200.00 Jane 100.00 Jane 400.0
Tom 100.00 John 100.00 Steve 300.00 Tom 300.0
Mary 200.0
Steve 300.0
The problem is that I want to do is consolidate the names and amounts in one worksheet
Worksheet A Worksheet B Worksheet C Consolidated Work Sheet (What I want
John 500.00 Jane 300.00 John 500.00 John 1100.0
Mary 200.00 Tom 200.00 Jane 100.00 Jane 400.0
Tom 100.00 John 100.00 Steve 300.00 Tom 300.0
Mary 200.0
Steve 300.0
The problem is that I want to do is consolidate the names and amounts in one worksheet