Query a dynamic range from another sheet in the workbook


Posted by Patrick on March 23, 2001 7:12 AM

I have a workbook with multiple sheets. The first sheet is for data entry. The other sheets are reports based on the firs sheet's data. I need a way to query the data and put it in various views and sorts in the other sheets. Any ideas? I would prefer not to use the ODBC query for external queries.



Posted by Dave Hawley on March 23, 2001 7:08 PM


Hi Patrick

I would go with a Pivot Table reading from Dynamic Named Ranges. This would give you what you need and more!. If you are not familiar with "Dynamic Named Ranges" follow my link to my website and click on "Dynamic Named Ranges"

Dave

OzGrid Business Applications