VB scripting in excel to hide columns for graph

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!

Evner: Excel, Visual Basic

Se mere: the graph, scenario presentation, Need help in excel, graph the data, graph of data, graph edge, for graph, edge graph, data to graph, data on a graph, data in a graph, data for graph, data for a graph, vb in excel, excel scenario, make a graph, vb excel, hide, excel to, excel macro combination, macros excel basic, range macro excel, sheet excel visual basic, excel 2014 macro, move data excel

Om arbejdsgiveren:
( 1 bedømmelse ) Wooloowin, Australia

Projekt ID: #5996828

Tildelt til:


Hi, I'll be happy to help you with this project. I can start on it now and finish it within 4 hours if everything is clear Please feel free to message me if you need to discuss any questions you might have prior to aw Flere

$122 AUD på 1 dag
(80 bedømmelser)

6 freelancere byder i gennemsnit $92 på dette job


Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

$100 AUD på 1 dag
(37 bedømmelser)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

$110 AUD in 0 dage
(38 bedømmelser)

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.

$55 AUD in 0 dage
(13 bedømmelser)

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in Excel/VBA project. I can provide you the be Flere

$54 AUD på 1 dag
(2 bedømmelser)

I have completed your macro for you. It begins by unhiding all columns and then hides the columns marked with a "0" flag. I have tested it on the sample workbook you have provided. If you aren't happy with your macr Flere

$111 AUD på 1 dag
(0 bedømmelser)