Named Ranges In QueryCell
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.
What can we do with the Named Ranges with QueryCell?
Since QueryCell automatically defines Named Ranges as tables/data regions you are able to :
– use SQL to join them to other regions of data
– Use them to populate data columns in the Test Data Generator
– 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!)