I gang

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!

Færdigheder: Excel, Visual Basic

Se mere: the graph, scenario presentation, graph edge, for graph, edge graph, excel scenario, vb excel, excel to, excel macro combination, macros excel basic, range macro excel, sheet excel visual basic, excel 2014 macro, move data excel, data hide, combination macro excel, excel record macro, excel input sheet, need excel macros, excel combination, macro combination data excel, visual basic scripting, excel macro range, excel macro columns, excel run macro

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

Projekt-ID: #5996828

Tildelt til:

zExcel

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 Mere

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

6 freelancere byder i gennemsnit $92 for dette job

dpune

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 Mere

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

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 Mere

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

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)
4.1
TypingMachine

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 Mere

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

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 Mere

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