Hi Friends,

A
1 Smart Plan
Single plan

2 ___________ (Premium for Smart Plan) ( user input)

3 ___________ (Premium for Single Plan) ( user input)

assume _____ is a A2 (Cell) , assume _____ is a A3 (Cell).

1. A1 Is in validation, Weather i was select the Smart plan Option, A3
will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A3,

2. A1 Is in validation, Weather i was select the Single plan Option,
A2 will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A2,


Pls kindly help and guide me , regarding above problem,

let me know any possibilites in excel formula or macro.

Regards,

deen

Do you want the words "(Premium for Smart Plan)" to appear in column
B? If so, you can just use one cell A2 for your input and enter this
in B2:

="(Premium for "&A1&")"

No need to hide A2/A3.

Hope this helps.

Pete

On Nov 26, 8:54 am, deen wrote:
Hi Friends,

A
1 Smart Plan
Single plan

2 ___________ (Premium for Smart Plan) ( user input)

3 ___________ (Premium for Single Plan) ( user input)

assume _____ is a A2 (Cell) , assume _____ is a A3 (Cell).

1. A1 Is in validation, Weather i was select the Smart plan Option, A3
will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A3,

2. A1 Is in validation, Weather i was select the Single plan Option,
A2 will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A2,

Pls kindly help and guide me , regarding above problem,

let me know any possibilites in excel formula or macro.

Regards,

deen

I need the data not like tht,

can you pls go thru the link i have attached the EG:excel sheet,

http://www.savefile.com/files/1224221

http://www.savefile.com/files/1224221

Regards,

Deen













On Nov 26, 2:52 pm, Pete_UK wrote:
Do you want the words "(Premium for Smart Plan)" to appear in column
B? If so, you can just use one cell A2 for your input and enter this
in B2:

="(Premium for "&A1&")"

No need to hide A2/A3.

Hope this helps.

Pete

On Nov 26, 8:54 am, deen wrote:

Hi Friends,

A
1 Smart Plan
Single plan

2 ___________ (Premium for Smart Plan) ( user input)

3 ___________ (Premium for Single Plan) ( user input)

assume _____ is a A2 (Cell) , assume _____ is a A3 (Cell).

1. A1 Is in validation, Weather i was select the Smart plan Option, A3
will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A3,

2. A1 Is in validation, Weather i was select the Single plan Option,
A2 will be a ' 0 ' (zero value) or Hide the Entrie row with 0 value of
A2,

Pls kindly help and guide me , regarding above problem,

let me know any possibilites in excel formula or macro.

Regards,

deen