ÿþ<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="icon" type="image/gif" href="favicon.gif"/> <title>Using Named Ranges In QueryCell</title> <meta name="description" content="How to use Named Ranges in QueryCell" /> <meta name="keywords" content="Excel, SQL, Named Ranges, QueryCell" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="Robots" content="index,follow" /> <meta name="Robots" content="noodp" /> <style media="all" type="text/css">@import "css/all.css";</style> <SCRIPT LANGUAGE="JavaScript" SRC="js/PopupWindow.js"></SCRIPT> <script type="text/javascript" src="./highslide/highslide-with-gallery.packed.js"></script> <link rel="stylesheet" type="text/css" href="./highslide/highslide.css" /> <script type="text/javascript"> hs.graphicsDir = './highslide/graphics/'; hs.align = 'center'; hs.transitions = ['expand', 'crossfade']; hs.outlineType = 'rounded-white'; hs.fadeInOut = true; //hs.dimmingOpacity = 0.75; // Add the controlbar hs.addSlideshow({ //slideshowGroup: 'group1', interval: 5000, repeat: false, useControls: true, fixedControls: 'fit', overlayOptions: { opacity: .95, position: 'bottom center', hideOnMouseOut: true } }); </script> </head> <body> <div id="root-box"> <!-- root-box --> <div id="main-box" > <!-- main-box --> <div id="root"> <!-- root --> <!--<div style="margin-left:30px;"> <table> <tr> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0470099518?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0470099518"><img border="0" src="images/Data-Analysis-Using-SQL-And-Excel.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0470099518" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0735640580?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0735640580"><img border="0" src="images/PowerPivot-For-Excel-2010.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0735640580" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/B0026OR2TK?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B0026OR2TK"><img border="0" src="images/Excel-And-Access.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=B0026OR2TK" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/143545751X?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=143545751X"><img border="0" src="images/The-Language-Of-Sql.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=143545751X" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> </tr> <tr> <td colspan="4" style="font-size:12px;"> Books that you may find useful (Click for reviews and pricing on Amazon) </td> </tr> </table> </div> <hr style="width:780px;"/>--> <div id="header"> <!-- header --> <a href="index.html" title="QueryCell">The Power of SQL in Microsoft Excel</a> <h1>Add-In the power of SQL to Microsoft Excel<sup style="font-size:55%;">&#174;</sup></h1> </div> <!-- end header --> <div class="top-menu"> <!-- top-menu --> <ul> <li><a class="menu1" href="index.html">Home</a></li> <li><a class="menu2" href="LearnMore.html">Learn More</a></li> <li><a class="menu3" href="BuyNow.html">Buy Now</a></li> <li><a class="menu4" href="TryNow.html">Try Now</a></li> <li><a class="menu6" href="Support.html">Support</a></li> <li><a class="menu7" href="About.html">About</a></li> </ul> </div> <!-- end top-menu --> <div class="learn-main" style="margin-left:20px;"> <!-- learn-main --> <div class="center-box-orange-block-nf"> <p> <a name="morescreenshots"></a> <h2 class="orange-text" style="line-height: 34px;">Named Ranges In QueryCell</h2> </p> <p><b>(ScreenShots are available below)</b></p> <p> You may have spent a lot of time defining Named Ranges to use in Excel. All that hard work won't go to waste when you are using QueryCell, because QueryCell automatically adds named ranges to the region grid. Assigning the named ranges a table name and allowing you to query and join them as if they were tables in a relational database. </p> </div> <a name="moreimage"></a> <font class="orange-text">&nbsp;&nbsp;Screenshots (Click to enlarge)</font> <br/><br/> <table width="100%" align="center"> <tr align="center"> <td align="center"> <div class="highslide-gallery"> <a href="./images/QC_ScreenShots/T5_SS1_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T5_SS1_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Named Ranges defined in Excel </div> <a href="./images/QC_ScreenShots/T5_SS2_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/T5_SS2_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> The Named Ranges appear at tables/data regions in QueryCell </div> </div> <!-- end gallery --> </td></tr> </table> <div class="center-box-orange-block-nf"> <h2 class="orange-text" style="line-height: 34px;"> What can we do with the Named Ranges with QueryCell ? </h2> <p> Since QueryCell automatically defines Named Ranges as tables/data regions you are able to : </p> <p> - use SQL to join them to other regions of data </p> <p> - Use them to populate data columns in the Test Data Generator </p> <p> - Easily convert them into SQL Insert statements that can then be run to insert them into a database. (you can connect to a database and run the SQL inserts from within QueryCell!) </p> </div> <div style="margin-left:7px;"> <div class="testimonial-box" style="margin-left:5px;"> &nbsp;&nbsp;"I'm very impressed with this add-in" &nbsp;-&nbsp; Dick, <a style="color: #D27302;" target="_blank" href="http://www.dailydoseofexcel.com/archives/2009/10/05/querycell/">Daily Dose Of Excel</a>&nbsp;&nbsp;&nbsp; </div> <!-- <div class="center-box-white-block-nf-np" style=""> <span class="orangeTitleText" style="color: #FC9200; font-size: 1.1em; text-align:center; background-color: #BDD4ED;">&nbsp;&nbsp;&nbsp;&nbsp;No SQL Server Required. QueryCell is a complete solution. Query with SQL in Excel!&nbsp;&nbsp;&nbsp;&nbsp;</span> </div> --> <br/><br/> <!-- <a href="LearnMore.html#moreimage"><img src="images/display.jpg" width="255" height="24" alt="" border="0"/> --> <img src="images/displayNoText.jpg" width="255" height="24" alt="" border="0"/> <!--</a>--> <div class="right-box"> <!-- right-box Screen and text --> <!--<h2 style="padding: 0 0 10px 0;">--> <p class="orangeTitleText"><em style="color: #20688D;">Query</em><em style="color: #0B3F5A;">Cell</em>&nbsp;&nbsp;is&nbsp;a Plugin for Excel&nbsp;that&nbsp; allows you to query using SQL within the Excel application itself.</p> <!--</h2>--> <ul> <li style="padding: 0 0 10px 0;"><b>Query Excel Data Using SQL</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Save time by selecting and joining data within Excel<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;using SQL, no database required.</li> </ul> </div> <!-- end right-box Screen and text --> <div class="cent-links"> <ul > <li style="padding: 0 0 10px 0;"><b>Query Access, SQL Server, Oracle, MySQL etc From Excel</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Run SQL Selects, Updates, Deletes and Inserts on your database without leaving Excel</li> <li style="padding: 0 0 10px 0;"><b>Generate SQL Insert Statements for Excel Data</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Need to move data from Excel into a database ? <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;QueryCell can generate SQL Insert Statements for Excel data in seconds <a style="color: #D27302;" href="SQLGenerator.html">more...</a></li> <li style="padding: 0 0 10px 0;"><b>Color Rows that match your criteria</b><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i>"I want to mark all the rows in worksheet1 where COLUMN_A is greater than COLUMN_B <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in Worksheet2"</i> It's easy with QueryCell <a style="color: #D27302;" href="ColorRows.html">more...</a></li> <li style="padding: 0 0 10px 0;">Supports Excel 2003, 2007 and 2010</li> <li style="padding: 0 0 10px 0;">QueryCell is Only $45!<p class="orangeTitleText">30 day money back guarantee!</p></li> </ul> </div> <div style="float: left;width:300px;margin-left: 40px; margin-top: 20px; margin-bottom: 20px; padding: 0;"> <!--<a class="buy-now-but" href="BuyNow.html">buy-now</a>--> <a class="download-but" href="downloadPopup.html" onclick="JavaScript: popitup('downloadPopup.html'); return false;">download trial</a> </div> <div style="float: right;width:300px;margin: 0px 0px 0px 0px; margin-top: 20px; margin-bottom: 20px; padding: 0;"> <!--<a class="buy-now-but" href="BuyNow.html">buy-now</a>--> <a class="buy-front-but" href="https://sites.fastspring.com/oakfocus/instant/querycell">Buy Now</a> </div> <div class="testimonial-box" style=""> &nbsp;&nbsp;"You've come up with something that genuinely enhances <br/>&nbsp;&nbsp;Excel's functionality, and I am more than happy to recommend<br/>&nbsp;&nbsp;it as such" &nbsp;-&nbsp; Geoff, <a style="color: #D27302;" target="_blank" href="http://excelicious.wordpress.com/2010/03/16/querycell-sql-in-excel/">Number Cruncher</a> </div> <div class="testimonial-box" style=""> &nbsp;&nbsp;"This is a tool any Power Excel User should check out...", <br/>&nbsp;&nbsp;"I can see this tool saving hours of time" &nbsp;-&nbsp;<a style="color: #D27302;" target="_blank" href="http://sqlrs.blogspot.com/2010/03/querycell-review-and-license-giveaway.html">BI/BPM - The SeeQueL</a>&nbsp;&nbsp;&nbsp; </div> </div> </div> <!-- end learn-main --> </div> <!-- end root --> </div> <!-- end main-box --> <br/><br/> <div class="bottom"> <!-- bottom --> <a class="logo2" href="index.html">logo</a> <ul> <li class="none"><a href="index.html">Home</a></li> <li><a href="LearnMore.html">Learn More</a></li> <li><a href="BuyNow.html">Buy Now!</a></li> <li><a href="TryNow.html">Try Now</a></li> <li><a href="Support.html">Support</a></li> <li><a href="About.html">About</a></li> </ul> </div> <div class="bottom"> <ul> <li>Copyright Oak Focus Software / QueryCell 2010 (All Rights Reserved).</li> </ul> <ul> <li>Microsof Excel&#174; is a trademark of Microsoft Corporation.</li> </ul> <ul> <li>The QueryCell Product and its website are not associated with Microsoft Corporation</li> </ul> </div> </div> <!-- end root-box --> <!--</div> end root --> <!--</div> end main-box --> <!--</div> end root-box --> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-8826822-1"); pageTracker._trackPageview(); } catch(err) {} </script> <!-- HitTail Code --> <script type="text/javascript"> (function(){ var ht = document.createElement('script');ht.async = true; ht.type='text/javascript';ht.src = '//92956.hittail.com/mlt.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ht, s);})(); </script></body> </html>