Consolidate worksheets

M

Maurice

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top