Google Spreadsheet Post #1881
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-11-2015
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
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.
Here is a link to the sheet I have been working on https://docs.google.com/
Thank you for any help you could give.
------------------------------------------------------------------
No comments:
Post a Comment