Hi, i am new to google spreadsheet...please help me out if you know what's
wrong with my 2nd Query command below:
=Query('SGD Transactions'!A1:T900,"select A,B,C,I,T where A>= date """&J2&"""
and A<= date """&K2&""" and B="""&J3&""" and T="""&M3&""" order by A desc")
=Query("""&A35&"""","select A,B,C,I,T where A>= date """&J2&""" and A<=
date """&K2&""" and B="""&J3&""" and T="""&M3&""" order by A desc")
Basically, i was trying ask Query to go to cell A35 where i could change
sheet name at A35. Example:
'SGD Transactions'!A1:T900
'USD Transactions'!A1:T900
'AUD Transactions'!A1:T900
'Euro Transactions'!A1:T900
The 1st Query command works perfectly but replacing it with """&A35&""" on
the 2nd command won't work here. Is there a way to do this correctly?
Kindly advise.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
