sujittalukde
05-15-2007, 09:51 PM
In my excel file, in one sheet user has to select option from drop down menu and in the another sheet excel should tick the appropriate box.
A sample file is attached wherein user will select Gender in sheet 1, cell B3. If the user select "M", a tick should appear automatically at cell B6 on sheet 2 & so on. How the same can be done?
A sample file is attached wherein user will select Gender in sheet 1, cell B3. If the user select "M", a tick should appear automatically at cell B6 on sheet 2 & so on. How the same can be done?