Just wondering if you know much about scripting vb in excel macros to help with graph presentation.
I am a macro “record” guy only and looking to make something a bit more dynamic.
I need to be able to run a macro that looks at whether a flag in a particular column is a 1 or a 0 (on or off) and if 0 then hide the column and move to the right and check that one etc – there are 10 columns and there could be any combination of columns on for a given scenario - Looking to graph only the ones that are on (flag of 1) and contain data. Hiding seems to be the most efficient way of doing it while keeping the data range to the edge of the 20th column.
The Macro should start by unhiding all 10 columns of data in the graph data input sheet.
I need this in the next 12 hours if that is possible!
6 freelancere byder i gennemsnit $92 på dette job
Hi: Please check my project reviews to know more about quality of my work and turnaround time. I can turn-around your project in few hours. Please connect to discuss more.