You need to create a way to select a value from the ribbon. The value is one of the letters: A, B, C, D or none. Let's call this the hide value.
Attached is an example of the Excel spreadsheet. We have collections of data. One collection is 9 cells, like the first one in A1 to I1. This collection of data repeats both on the rows below (to about row 50) and in the columns to the right (to the right, the collections are separated by a divider-cell), it is 5 collections on one row (shown in the example is only 2).
So the macro will work in the following way:
- If no hide value is chosen, show everything (the default, like it is now)
- If hide value is set, for example to "A", then hide all collections that have the letter "A" in the 4th or the 9th cell.
You must also instruct me how to install this macro and how it actually works. I am a developer myself, but not working with VBA, and I am not so much familiar with Excel.
28 freelancers are bidding on average $28 for this job
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience Excel VBA Proposed Milestones $30 USD - ex
Dear Client I can do this task for you. I have previously carried out a number of projects in excel using vba macro. Kindly contact me for further details Roy
Dear client, Please share the file. I can do that task for you using VBA. Regards Relevant Skills and Experience Excel, VBA Proposed Milestones $30 USD - Complete Project
I can make this successfully, please contact me Relevant Skills and Experience worked on Excel and VBA for past 7 years Proposed Milestones $35 USD - Charge
Hi, I am interested in working on this task. Looking forward to discuss Relevant Skills and Experience I have worked with Excel Macros for more than 5 years Proposed Milestones $25 USD - Task Completion