Hey all....
Here's my dilemma...I'm building a report that will be distributed to the management on at least 15 different tabs, and the first tab and then the first 9 rows on each tab thereafter are all formulae. I need to have the dispatchers in my group be able to run this through CRXI where they pick they 5 parameters, hit the button and poof! it's there as a complete workbook. The Excel part is easy, and the CRXI Report part is easy; what I'm having extreme difficulty with is figuring out how to have the reports export to where I want them within the Excel template. I've started reading up on XML, but that doesn't look like it's going to work. I was going to have the dispatchers pull each report separately, but when you're looking at 15 individual reports over 30 Contractors for every month, that is a little bit of stupidity.
There are lots of people here who are a helluva lot smarter than I am, so I would appreciate any feedback or suggestions.
Thanks!!!!
Chris