tag:blogger.com,1999:blog-3979648284880167220.post814354605401393018..comments2024-03-07T01:46:22.570-08:00Comments on tech cogitation: Updating Google Sheets and Awesome tables with Access queriesJameshttp://www.blogger.com/profile/08512693901366641948noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3979648284880167220.post-53365321181691492472014-06-18T04:04:23.154-07:002014-06-18T04:04:23.154-07:00Hi Sally - I know we have spoken off-line - but wi...Hi Sally - I know we have spoken off-line - but will answer your question here too in case it is of interest to others. <br />The master spreadsheet is just a Google Sheet that you create which will contain the script and pull in information from your 'child' raw data sheets. In this master spreadsheet, you just need to have a worksheet called FindKeys - the script will populate this worksheet with the names and keys. Cheers. JamesJameshttps://www.blogger.com/profile/08512693901366641948noreply@blogger.comtag:blogger.com,1999:blog-3979648284880167220.post-19225657504655408432014-06-17T04:04:13.129-07:002014-06-17T04:04:13.129-07:00Sorry, and where do you store your master Google a...Sorry, and where do you store your master Google and FindKeys sheets?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3979648284880167220.post-77474324952212652242014-06-17T04:01:55.435-07:002014-06-17T04:01:55.435-07:00Hi James, Sally here! I am new to trying things ...Hi James, Sally here! I am new to trying things out in Google, so please bear with me. I've come across this post and am keen to have a go. I have created a query in Access, exported to a local folder and imported it as a google document. That's all fine. However, I'm now stuck. What do you mean by "On my master Google sheet, I have a sheet called "FindKeys" "<br /><br />What is a master Google sheet and did you create the sheet within Google called FindKeys ??<br /><br />Many thanks for any help,<br />SallyAnonymousnoreply@blogger.com