How do I add values across files

Hi,

Adding values across files:
 
I send out blank Excel order forms, with a total of c. 50 product lines, spread over 3 worksheets, to individual clients.
I receive back completed order forms from the clients.
They all order different items.
 
Is there a simple way to add each individual's order to a master file, so I know the total of each product line that I should order from my supplier?

Thanks very much indeed.

Comments
There are 5 comments. Login or register to view them.

Try Consolidate Data in Excel

neileg |

How about an online database

Saffuze |
Saffuze's picture

yes

listerramjet |
listerramjet's picture

Combine all the worksheets into one, then use a pivot table

David Carter |

VBA Solution

saltimbamba |