With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, January 11, 2015
yogi_Pull From Sheet Named 'MASTER' Values For Non-Blank Columns Of A Specified Name In Column A
post by vaughanF1: https://productforums.google.com/forum/#!searchin/docs/automoatically$20hide$20columns/docs/dhi_LpaPFvk/O1nC_XREM0AJ Hide Columns while using a query and import function
I've searched many forums and have found a couple of options of hiding columns that have no values, but I can't seem to put the formula together with the other formula's I am using.
My existing formula is =QUERY(MASTER!A:V,"select A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V where A contains 'MARCEL' order by A",2)
These are the problems I need help with:
1. Not all of these columns will have values where A contains 'Marcel', so I need some help with using the best way to hide those columns with no values. I was trying the filter option, but happy with any.
2. Is there anyway to import the formatting of the cells? When I import now it's only the values that come over. It would be great to have the orange fill colour import into my other sheets as well.