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!
34 freelancers are bidding on average $77 for this job
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
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
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
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!
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
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