In Progress

Excel macro to hide content of certain cells

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.

Skills: Excel Macros, Excel VBA

See more: excel macro copy paste empty cells, excel macro cut certain cells, excel macro capture content internet, excel macro copied content, excel macro copy content, excel macro enter data emply cells, paste content cells excel macro, excel macro cell content, move content cells excel macro, excel macro find content cell, excel macro cell content copy, excel macro insert data textbox cells, excel macro copy cells, excel macro copying cell content, excel macro fill empty cells

About the Employer:
( 12 reviews ) Gardermoen, Norway

Project ID: #15607102

Awarded to:

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 More

$25 USD in 1 day
(8 Reviews)
3.2

28 freelancers are bidding on average $28 for this job

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 More

$31 USD in 1 day
(7 Reviews)
4.4
AhmedHassan1122

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

$25 USD in 1 day
(10 Reviews)
3.7
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

$30 USD in 1 day
(4 Reviews)
3.1
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

$50 USD in 1 day
(9 Reviews)
3.7
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

$30 USD in 1 day
(2 Reviews)
2.9
aubrey03

A proposal has not yet been provided

$30 USD in 1 day
(7 Reviews)
3.0
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 More

$27 USD in 2 days
(2 Reviews)
2.4
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 days
(2 Reviews)
1.8
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

$25 USD in 1 day
(4 Reviews)
1.8
JackieXu

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard. Relevant Skills an More

$20 USD in 1 day
(2 Reviews)
1.4
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

$25 USD in 1 day
(1 Review)
0.8
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 More

$30 USD in 1 day
(0 Reviews)
0.0
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 More

$20 USD in 1 day
(0 Reviews)
0.0
$12 USD in 1 day
(0 Reviews)
0.0
MincaCons

Highly efective VBA programer Habilidades y experiencia relevante Excel, Macros, VBA Htos propuestos $25 USD - Problem Analisys and Solutions

$25 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
XcelSolution

I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones $10 USD - Excel f More

$10 USD in 3 days
(0 Reviews)
0.0
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 More

$55 USD in 3 days
(0 Reviews)
0.0
andreapellicci

Create a macro that reads text in col 4 & 9, search the collection and works on it. I need information on what you mean with "hide": delete, color in white, ... or what? I'll explain all code. Competenze ed esperienze More

$25 USD in 3 days
(0 Reviews)
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 More

$35 USD in 1 day
(0 Reviews)
0.0