LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Multiple sheet querries

I want to bring a lot of data into Excel from a database. Using SQL I
can retreive much more data than one worksheet can hold.

I have found I can create and name a range that includes multiple
worksheets.

If I retreive 80,000 records from a database can I import them into my
multi-sheet range?
Does Excel recognize such a range as a contineous list of data?

I want to analyze this type of data with averages and statistical
functions and create graphs to show the results of my analysis.

Will Excel be able to graph across my multiple sheet range?

Thanks
Glen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
presenting data on multiple sheet on one consolidated sheet Jammings Excel Worksheet Functions 2 October 7th 09 10:56 PM
Stumped on establishing web querries on MS Excel Chris Excel Discussion (Misc queries) 9 August 16th 09 04:23 PM
Average Over Multiple Sheet Tabs with Multiple Values Karen Excel Worksheet Functions 6 February 4th 09 02:29 PM
lookup single value in one sheet, return multiple results from theother sheet Chuck[_3_] Excel Worksheet Functions 1 April 4th 08 06:17 AM
Create multiple sheet tabs from multiple cells. Robert Maddox Excel Worksheet Functions 17 November 14th 07 10:28 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"