I have a spreadsheet "Customers" with Customer account numbers in Rang
(A1:A90).
On Sheet "Template" I have some sales data which uses the accoun
number occupying Wks."Template".Range("A1") to perform some looku
calculations.
I want to use a Loop statement to Pass the Customer code in the
"Customers" spreadsheet to the Template sheet and then output the fil
toa specified path such as : "C:\MyReports\".


Currently I use 1 sheet per customer and a lot of code to output thes
files in a macro. But it strikes me this could be done with a loo
statement pretty easily.

Can anyone put me out of this misery? would really aappreciate it.
Cheer

--
Message posted from http://www.ExcelForum.com