Sunday, January 11, 2015

yogi_Pull From Sheet Named 'MASTER' Values For Non-Blank Columns Of A Specified Name In Column A

             Google Spreadsheet   Post  #1881
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-11-2015
post by  vaughanF1:!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.

Thank you for any help you could give.