How do you automatically hide columns? If there is some way that a column automatically hides when there is only zeros / blanks that could work.
Where/how could I post my data? Can you post data on this site?
Thanks
Hi Hui
I am trying to avoid doing that as I have a full sheet of columns and the data changes monthly - something that was zero this month may be populated next month etc etc - the data is organised like this:
KB ZZ DD QR
12 0 33 44 .... etc etc across an entire sheet of columns, 7 x...