Excel macro to hide content of certain cells

Tamamlanmış İlan edilme: 6 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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.

Excel Macros Excel VBA

Proje NO: #15607102

Proje hakkında

26 teklif Uzak proje Aktif 6 yıl önce

Seçilen:

riccardopepe

Hi. I'm interested in this project. Contact me, I have some questions for you (for example where you want to select the "hide" value). Relevant Skills and Experience Working in IT area since 10 years. A lot of experie Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(9 Değerlendirme)
3.2

Bu iş için 26 freelancer ortalamada $28 teklif veriyor

aubrey03

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(44 Değerlendirme)
5.4
schoudhary1553

Greeting, I have understood your Excel macro to hide content of certain cells task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 yea Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)
5.1
AhmedHassan1122

Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones $25 USD - Full Price

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(16 Değerlendirme)
4.4
AkilaArun

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
4.3
TonmoyRoy111

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
4.3
qasimalikgmail

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.8
chintuag

Dear Hiring Manager, I have read the project description and would like to offer my expertise for it. I have worked on several projects in VBA and recently closed few. My work includes, but not limited to, Macros, Ch Daha Fazla

$27 USD in 2 gün içinde
(5 Değerlendirme)
3.4
MohsanEijaz

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
3.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
3.3
prabakarm23

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

$35 USD in 2 gün içinde
(2 Değerlendirme)
1.8
johser

Hello. Please give me original xls-file. And explain in details how you want to hide rows . Relevant Skills and Experience VBA Proposed Milestones $25 USD - v

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.8
vivirain

Hi there, Hope you’re doing well. I’m quite familiar with Excel VBA and interested in the job. I can get it well done quickly within 1 day once getting hired. Feel free to contact me and discuss more details. Best Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.8
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Relevant Skills and Experience excel VBA Proposed Milestones $30 USD - Full

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.5
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks. Relevant Skills Daha Fazla

$55 USD in 3 gün içinde
(0 Değerlendirme)
0.0
andinfini

Hello, With 9 years experience in VBA programming and macros for excel as well as VB application development, I can help you whatever you need for this software Expérience et Compétences appropriées - MACRO & VBA (fo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
izzatannous

I am a computer science graduate and I am dealing with such data on every day basis. I will ensure you the outcome needed in a timely manner and with the efficiency needed to complete the job. Relevant Skills and Expe Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sonarkaushik

I am very able to create and develop this macro

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
anthonydoctor200

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
kantormk

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
vsprybhanu

Hi, I have developed this type of program with similar logic. So, can do this job nicely. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manip Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
2.4