I'm trying to figure the best way to provide some end user summaries. I have end users who like to export data into Excel out of a program we use. I want them to be able to have a report that draws off of this, summaries, etc. What is the best way to do this? In a summary worksheet that they lay on top of it? I want the summary to be based on data in the worksheet. Is there something else available that I am not aware of that wouldn't require much regarding linking the two (summary report and the data). Thanks for your expertise.

What? Your pronouns have me confused.

What? Your pronouns have me confused.


:lol: glad I wasn't the only one

Well it depends on where the data is being pulled from. Is it a database program such as MS Access or SQL Server? It is another spreadsheet? A little more information would be helpful.

Sorry that I confused anyone who was trying to help me someone who was trying to provide anyone with something that helped them anyhow. Pronoun defecation over.

Okay, so here is the deal. Export out of sql server program. Goes into Excel. Formatting is crap out of excel each time. Hoping to write something to lay over the excel export so that that data makes sense. I could write a crystal report, but that gets tricky so wondering if there is a better option of a summary worksheet that calculates based on another worksheet. How do I do this, just create a worksheet and have it call on the rows/columns in another worksheet? I don't want the people that are using it to have to put the formulas in for the summaries, but have it 'refresh'.

I think I only used one pronoun there. Then again, I did a lot better in math than english.

Thanks for your help, patience and guidance!!

Sorry that I confused anyone who was trying to help me someone who was trying to provide anyone with something that helped them anyhow. Pronoun defecation over.

Okay, so here is the deal. Export out of sql server program. Goes into Excel. Formatting is crap out of excel each time. Hoping to write something to lay over the excel export so that that data makes sense. I could write a crystal report, but that gets tricky so wondering if there is a better option of a summary worksheet that calculates based on another worksheet. How do I do this, just create a worksheet and have it call on the rows/columns in another worksheet? I don't want the people that are using it to have to put the formulas in for the summaries, but have it 'refresh'.

I think I only used one pronoun there. Then again, I did a lot better in math than english.

Thanks for your help, patience and guidance!!

Nothing that I know of. Maybe exporting out of SQL Server into XML.