Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel - Auto Generating Pages

Jul 12, 2004 4:50PM PDT

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

Discussion is locked

- Collapse -
Re: Excel - Auto Generating Pages
Jul 13, 2004 4:20AM PDT

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

- Collapse -
Re: Excel - Auto Generating Pages
Jul 13, 2004 8:07AM PDT

Thanks for the input Bob. I like the .csv idea, but I have some reading to do for VB - it's been a while. Thanks again.
Joe