Help Wanted to create a macro for applying functions / charts to multiple workbooks.

Hello everyone I am completely new to VBA / programming. Actually completely new to any kind of forum, anywhere, ever. I checked out some of the links provided on this site and I'm very interested in learning this stuff. However I have a complex issue and I don't expect to figure it out in a day - my employer thought it would be cool if I could make graphs of some of our trucking data.

First issue: I have workbooks based on every client we pick stuff up from. The office admin takes the tonnage of the load and records it in a small table which for some reason is cleared at the end of every billing cycle, and started over. I wanted this data to automatically compile on a separate sheet for starters (i could just have them start making bigger lists I guess). I had an IF function going with a circular reference that would pull info from the first table and it would remain when the table was changed, but it's iffy. It would be pretty slick if I could get a macro to get this to work properly.

Second issue: I would like to graph this data - but I want it to show up as a continuous line, and not as separate series lines. Ideally, I picture tonnage on the Y axis and labels on the X axis that break up the billing periods. I hate the idea of stacked series lines, you just can't see changes chronologically.

Third issue, least imporant: apply this to all 30 or so workbooks, which would include creating the necessary tables, inserting functions, and charting all automatically. I can do this by hand but I hear macros can do it for me! Formatting not necessary, I think this is enough of a problem.

I would very much appreciate any help. I have attached a sample book with comments / highlights. Most important would be figuring out that compiling table and making a graph I can use. This would be major points at my new job, FYI.

Originally Posted by arlu1201

This seems to be a big project and since this is a voluntary forum, not everyone would have that much time to do it from end to end for you.

Its better you break it up into pieces and create one thread per piece. This will make it easy to handle and multiple people can help you to solve all the pieces.

Thank you very much I will do that!