I would like a macro that merges or unmerges cells on two sheets based on an adjacent cell value (1, 2 or 3). I also need it to hide a series of rows on two sheets based on a different cell value. For example, in the attached file, if cell G8 on sheet MASTER is changed from 1 to 2, cells A8 and A9 would merge, cells F8 and F9 would merge and cells G8 and G9 would merge on both Master sheet and sheet PRINT. If G8 is changed to 3, A8, A9 and A10 would merge, F8, F9 and F10 would merge and G8, G9 and G10 would merge on both sheets. If the G cell is changed back to 2 or 1, the A, F and G cells would follow suit. Likewise the same operation is required for cell L8, L9, and L10 merging and unmerging the associated cells in L, M and R. This operation applies for all rows 8 through 28.
I also need to hide rows 17-28 on sheets MASTER and PRINT if MASTER cell A3 is selected as 18 or hide rows 23-28 if Master cell is selected as 30. No rows are hidden if Master cell A3 is 42.
In the end of any macro operation, sheet PRINT needs to be in a protected state. The password to unprotect sheet PRINT is "unprotect".
Hello,
I am an Excel expert. I have checked the attached Excel file and clearly understood your detailed instructions. I offer my services to create macro to merge/unmerge and hide/unhide and protect.
You can check my reviews for quality of work and client satisfaction.
Looking forward to working with you.
Thanks,
Hamid
Hi Hope you are doing good,
I can perfectly help you with that in quick turnaround time.
I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Kind Regards
Arun
Hey
, I have the best terms of service with diverse multiple skills and experience in Excel and Visual Basic , feel free to negotiate with me for a better deal. I will give you comprehensive, detailed, exceptional and high-quality results before your deadline
I can do all kind of database design development programming and optimization
Access Database & UI Development
Forms
Tables
Reports
Queries
Macro Development
Relationship Structure
Credential Management
Login Panel
Access to MS SQL Server Connectivity
Fixing problem and customize development
Any database projects
ER-Diagram
Schema Design
Primary Key, Foreign Key, Unique Key, Default Values
Constraints
DDL
DML
DCL
Table structure
procedure
views
functions
queries
indexing
Administration
Joining
Query optimization
Performance tuning
ETL Process
Triggers
Advanced database techniques
CTE
Backup
Recovery
Replication
RMAN
Data Guard
Log Switch
Trouble Shooting
If you are looking for below list you are in the right place
Team Management
Sales Management
Employee Database
Admin Inventory Management Systems
or Any Customized DBMS