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:
( 0 bedømmelser ) Sigli, Japan

Projekt ID: #5996871

34 freelancere byder i gennemsnit $77 på dette job


Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

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

Easy Job! Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link then you will notice tha Flere

$35 AUD in 0 dage
(130 bedømmelser)

Hi, Just wondering or want apply the code? Please test my sample file to hide or unhide columns based on flag in row 1: [login to view URL] Press ctrl+q to hide Flere

$35 AUD på 1 dag
(123 bedømmelser)

Hi, I can hide the columns using VBA in Excel. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. Flere

$40 AUD in 3 dage
(73 bedømmelser)

A proposal has not yet been provided

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

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom

$45 AUD på 1 dag
(11 bedømmelser)

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have many years of experience working with macros and writing code / debugging Excel VBA code. You may che Flere

$53 AUD in 0 dage
(9 bedømmelser)

Hi - All you need to know is more on variables, conditional statements, and loops to make your recorded Macro code dynamic. ;) I can deliver this in 3 hours once you send me an updated file. Regards Vishy

$35 AUD på 1 dag
(8 bedømmelser)

Hello there! I think I’m the right person for this job because, I work with excel/VBA for several years, I’m responsible and I promise you won’t regret hiring me! Regards, Filipe Ramos

$155 AUD in 3 dage
(1 bedømmelse)

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)

Hi, My name is Dan. I can do this code for you so that you can hide and unhide based on the flag. Please message me. I can do this immediately for you. Thanks ! Dan

$30 AUD in 0 dage
(4 bedømmelser)

Just send me the file if you can. That way I can start working on it right away. I'll let you know when I'm finished, which would hardly take much time. You can accept my bid after that. Thanks!

$45 AUD in 0 dage
(4 bedømmelser)

Hello! I worked as an analyst in several retail companies for over 10 years and I have extensive experience in software development and automation using Excel, including VBA Coding, Macros, PivotTables, Charts/Graphs, Flere

$150 AUD på 1 dag
(1 bedømmelse)

I dont know why you are spending on this when you can google it easily?. You'll find tons of code for FREE. But still, if you want to proceed I can help you out. Just 30 - 45 minutes job. Regards Ranga

$35 AUD på 1 dag
(1 bedømmelse)

I am well qualified .NET Desktop and Web Developer. I am experienced in VBA for MS Excel, MS Word MS Access and Facebook Custom Tab Development I have a strong skill set and foundation in ASP.NET, VB.NET, CSS and C# Flere

$100 AUD in 3 dage
(2 bedømmelser)

Hey I can do this for you right away. I'm available if you need it done. I'm a Microsoft Excel specialist, experienced in VBA coding. Thanks.

$55 AUD in 0 dage
(1 bedømmelse)

I am an engineer and I have good skills in Excel VBA Macro programming. I am a new user of, my objective right now is to build my reputation, that's why I put a competitve price. Please give me a chanc Flere

$30 AUD in 3 dage
(1 bedømmelse)

Hello. I am new here but not new to excel. I have over 10 years experience and can have this done within 30 minutes or less for you once excepted. I appreciate your consideration. Shelton

$35 AUD på 1 dag
(1 bedømmelse)

Hi , I have worked on excel graphs in macro. I had got your requirement and can work soon. You can let know for your work.

$30 AUD in 3 dage
(0 bedømmelser)

Hi, I am a professional Visual Basic Application Developer, expert in Advanced VBA Macros development, currently working with CapGemini India Pvt Ltd. Mumbai, looking out for part time/freelancing jobs in same field Flere

$35 AUD in 3 dage
(0 bedømmelser)