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.