Lukket

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

Projekt-ID: #5996871

35 freelancere byder i gennemsnit $83 for dette job

zExcel

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)
6.2
koolsidz

Easy Job! Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice tha Mere

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

Hi, Just wondering or want apply the code? Please test my sample file to hide or unhide columns based on flag in row 1: https://dl.dropboxusercontent.com/u/63939243/Hide-Unhide_columns.xlsm Press ctrl+q to hide Mere

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

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. Mere

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

A proposal has not yet been provided

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

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

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 Mere

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

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)
3.5
uframos

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)
2.3
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)
2.1
dank111

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)
1.9
lxqcad

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)
1.8
ssviatlana

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, Mere

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

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)
1.4
othanorthington

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# Mere

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

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)
1.1
hammougua

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

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

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)
0.4
bhumika42

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)
0.0
binitabiswas9

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 Mere

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