![]() My goal is to have just input cells and trigger the lookup again and populate the target cells with a button (or cell selection event). ![]() If I refresh using Data > Refresh Range, I get the query parameter prompt and the output table updates as expected.I drag the results into some target cells.I get a prompt to enter the parameter value.My query is working fine when run it manually ![]() I have a separate tables in calc display the results:Īnd an input table to filter to be used as input: I have a an SQL query along the lines: SELECT AVG(Col1), AVG(Col2) FROM mytable ![]() Hope someone can help point me in the right direction. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |