Search results for query: *

Hi Skip, Thank you for all your effort. As you indicated, I have a solution -- not an ideal one, but better than none. It seems like pivot and query tables are wholly different animals, regardless of whether you built your pivot from data assembled by MS Query. I hope that Microsoft plans to...

Hi Skip, I appreciate what you're saying but I would prefer not to double the size of my workbook. By this I mean that I can't remove the original 14 worksheets with the split-up data. So, if I create a consolidated data sheet (whether by using MS Query or copy and paste), I'm going to end up...

By "Excel-Side", I meant in the main Excel view (i.e. looking at your spreadsheet) rather than, for instance, in the VB Compiler or the MS Query tool. Sorry, just a bit of work lingo I threw in without thinking. So, to carry the explanation a bit further, I was wondering if I should have saved...

Hi Skip, To answer your question: "Are you saying that in the PT wozard, this was your extrenal data source?" I fed 14 named ranges (1 for each Worksheet) into MS Query, used the SQL to mash them into a single data source, and exported that data back to Excel as a Pivot Table. I entered the...

Hi Skip, Thanks for your reply. Believe me, if this workbook were my creation, I would simply rollup the data on one sheet as you suggest and be done with it. Unfortunately, I didn't design the Spreadsheet and can't alter its visible form. Are you saying that this approach to solving the...

Hi there, I had a quick look through your FAQ and related subjects and couldn't find what I was looking for. I am a bit pressed for time, so please excuse me if I have missed an existing resource. Before I explain my problem, a caveat: I am more of an end-user than a developer/programmer. I...