Previous Topic Next Topic

Editing be done in particular sheets

Closed
Amit - Jun 1, 2009 at 06:25 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 3, 2009 at 12:33 AM
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
Related:

1 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
Jun 3, 2009 at 12:33 AM
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 ......


0

Similar discussions

regedit is disabled by the administrator
9845 -
Benji -

89 responses