| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Loop Statement to Pass Data between WKS and Output File
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel VBA: sending output data table to created .csv file +append Options | Excel Discussion (Misc queries) | |||
| Need Help With Loop That Creates Output File | Excel Discussion (Misc queries) | |||
| How to pass a variable into an SQL statement | Excel Discussion (Misc queries) | |||
| Error on second pass of loop. | Excel Discussion (Misc queries) | |||
| error on second pass of loop. | Excel Discussion (Misc queries) | |||
Threaded Mode
