There are two components for works required for attached spreadsheet;
1) Create text code and give advice to create a single button to hide all rows that have a 0 in column A + Hide 0 Columns in sheet 4 F2 & G2. All Rows / Columns will hide / not hide driven by the number 0 or 1 at start of each row / coloumn. These are all highlighted pink.
2) Create text code and give advice to Hide 0 Tenant Rows only in sheets 2, 3 and 4. These are all highlighted green.
Each item above needs top have a single button to hide and unhide.
Item 2 needs to start hidden when first spreadsheet is open. Selection is driven from E9 on sheet 2.
I don’t want someone to do this and give me the completed sheet, but write the code in text and give me instructions as to how to set it up.
Hello! I can write the VBA script for you and also explain you how to use it. I am available today. Thank you! I have a big 31% rehire rate.
Bu iş için 25 freelancer ortalamada $80 teklif veriyor
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Daha Fazla
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application's rows hidden/unhidden. I plan to use a combination of formu Daha Fazla
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I can do this job and review my profile for more details. I am financial experts and a guru in Microsoft Office/Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual B Daha Fazla
Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I understand the scope of work involved in the project. Kindly contact me. Roy
Hey, I can create a macro and add it to your spreadsheet. That will be linked to a button and when the user clicks it, the desired rows would be hidden from view. I am an expert in Excel and can deliver this to you in Daha Fazla
Hello, My name is Luis and I will be glad to assist you with your project. I can write the code and send you the instructions how to set it. Please contact me by chat then we could discuss further details about your Daha Fazla
Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.
Hi, Thanks for your job posting. I've read your project description carefully. As a senior VBA developer, I have rich experience in this kind of works. If you have desire to work with me, please respond me. Thanks
Hi. I am excel and VBA expert. Having read and understood your project details am available to start the work now and deliver in one day. I will precisely give you the instructions required to complete this work. Thank Daha Fazla
Ready to accept this task. Everyone can sell themselves with words, i know that i dont have words but works. 10 years working with data, can not be shadowed by a new freelancer profile. Please try me and you will be n Daha Fazla
Dear sir/ma, I'm interested in taking this task up for you. I am an expert in the field of handling any job on EXCEL and also I have good command over MS Excel especially pivot table, charts, advanced formulas, format Daha Fazla