Adding data from multiple worksheets of the same type

L

Leonp

Hi,

Please can you advise?
I have created an order form to send to clients each week.
They type the number of each product that they want to buy into the Quantity
column, cell 1,2,3 etc. according to which item they want.

How can I total all the clients ' weekly orders, from each cell in the
Quantity column, into a single master file, with the total at Quantity
column, cell 1, 2, 3, etc. so that I can simply send the master file straight
to the cash and carry store?
Thanks very much
Leon
 

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

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Merging from an Excel file with graphics 1
Format column widths from one table to a separate table on same page 1
Embed the same Excel multiple times 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Please help me choose a product for the task 2
Can the IF function be used with values from multiple worksheets? 4
Averaging Data across multiple sheets 0

Top