Hello everyone,
I am trying to do something a little strange, but I hope that it can be done as it will simplify my life considerably. I have an Excel workbook. The data is on one tab and I want the user to view the results on a second tab. Using variables chosen by the user I would like to use an SQL Statement to query records from a named range on the data tab and display the result on the report tab. I can do the SQL statement just fine, but how do I get it to show up in the correct place on the Report tab? Thank you for your help.
ChaseMIS
I am trying to do something a little strange, but I hope that it can be done as it will simplify my life considerably. I have an Excel workbook. The data is on one tab and I want the user to view the results on a second tab. Using variables chosen by the user I would like to use an SQL Statement to query records from a named range on the data tab and display the result on the report tab. I can do the SQL statement just fine, but how do I get it to show up in the correct place on the Report tab? Thank you for your help.
ChaseMIS
