View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G Ray G Ray is offline
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