Given you know VB, why not export that sheet to some .CSV and write a VB app to read, parse and print the results you want?
Or use VB and talk to Excel to read the data, parse and print your results?
To do this in Excel via a macro is too much work for me. I'd do it outside.
Bob
Hi,
I have a worksheet with a list of customer names (around 60), and other columns (for each month) with the calculated amount owed by each customer. I would like to create another sheet that could auto-generate seperate, formatted statements for each customer, at the end of each month - so, for instance, it could say John Doe, you owe $100.00 for May 2004. I do have some programming experience (C,C++,VB,ASP), and realize this may be a little too in-depth to provide a complete answer; so if anyone has any recommendations on some online tutorials or any explanation on how to accomplish this (macros?), any input would be greatly appreciated.
Thanks for your help,
Joe

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic