Adding values across files

  • Thread starter Thread starter Leon Pein
  • Start date Start date
L

Leon Pein

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.
 
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.
Click to expand...

I would probably suggest a macro that opens each file and searches for
what you want and imports to the master sheet. Or, formulas that do
the same without opening. Best to see the master and one or more
slaves with a complete explanation., (e-mail address removed)
 
Back
Top