Sunday, September 7, 2014

yogi_Pull Data From Certain Field For WeekNumber Associated With Date in Cell N1

                      Google Spreadsheet   Post  #1754
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-07-2014
post by gbah:
(https://productforums.google.com/forum/#!mydiscussions/docs/badkFo_BXvk)
Query a closed NEW Google Spreadsheet
I am using New Google Spreadsheet, I have migrated my project over from the old sheet.  The problem I have is that when i do a web query to the google sheets the spreadsheet shows nothing.  if the spreadsheet is opened then all is fine.  I am using query visualization (select A, B,) EXAMPLE
---
here it is again i hope is edit version

---
so i have been unable to find away to add week number function to a query url unless ip put it in manually.  is there away to place the date in sheet1!N1 and have the query url reference that cell select A,B,C,D,E Where C="sheet1!N1" i have tried tjis approac and all i get is the headers of each selected columns