Hi,

I am looking for an Excel Macro code which can activate a section of worksheet and make it visible for editing basis an input selected on 1 cell. With the changes in the input selection, different range should get activated and be visible.
E.g.
Step 1 - Input / choose option from cell A2 - Options being - 1. Completed 2. Pending (chosen from a Drop down list - Data validation)
Step 2 - Basis Option 1 chosen, Cells A14:I45 becomes visible for the user to input data. Input is completed, data is saved by user.
Step 3 - Option 2 is chosen, cells A50:I90 becomes visible for input.

Till any of the options not chosen, A14:I90 are invisible.

Kindly help me in writing the Macro code for the same.

Thanks much for your help.