IN Excel, how can I import a monthly sales file for 100's of stor.

[mtrplato]

I have an Excel file with several hundred stores and their operating data,
but I want to update the file with sales data from a monthly sales report.
How can I import sales from the Excel sales file into my Excel store file.
Both files have stores listed by number.

Thank you.

 

[LanceB]

If I understand you, the easiest way is to open both files. In the store file
where you want the total from your month sales sheet, begin the formula

=sum(
then using the window menu item select the monthly sales sheet and

select the range you want to sum and hit the end parenthese. Your formula in
your store sheet will look something like this:

=SUM([MonthlySalesReport.xls]Sheet1!$G$1:$G$18)

Lance