Editing be done in particular sheets [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I have 4 sheets in a workbook,
one sheet where i would input the parameters name it Input, & other sheets where it would b updated.

suppose the sheets tht wud get updated are named A, B, C,D

in the input sheet i hav a cell which has 2 values e.g. 1 & 2
when i give input as 1 all the parameters should b updated in Sheet A & C & when 2 is the option values be updated in Sheet B & D.

Pls help me with this problem

It would b very gr8ful

Thanking u

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
You would rather to put conditions in your Sheet A to D , while input sheet update ...

Suppose your Sheet1!A1 = 1 or 2 then in your Sheet A & B cells A1 must have this condition

Sheet A & C : A1=IF(input!A1=1,"Yes option one is clicked","")

Sheet B & D : A1= IF(input!A1=2,"Yes option TWO is clicked","")

Hope it will make some sense to you ......


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!