Change cell by clicking on another cell
Closed
Sedicee
Posts
3
Registration date
Monday June 29, 2015
Status
Member
Last seen
July 6, 2015
-
Jun 29, 2015 at 07:19 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 7, 2015 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 7, 2015 at 11:37 AM
Related:
- Excel click on cell to change value of another cell
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Highlight cell if another cell contains specific text - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 2, 2015 at 11:17 AM
Jul 2, 2015 at 11:17 AM
Hi Sedicee,
So you want to change the value of the cell, two cells left of the chosen cell.
This could be done by double clicking the cell (to auto run the macro), but what change to the cell needs to be made?
Best regards,
Trowa
So you want to change the value of the cell, two cells left of the chosen cell.
This could be done by double clicking the cell (to auto run the macro), but what change to the cell needs to be made?
Best regards,
Trowa
Jul 2, 2015 at 04:47 PM
Jul 6, 2015 at 10:28 AM
Could you give an example with cell references and to what range it applies?
Best regards,
Trowa
Jul 6, 2015 at 04:53 PM
Here's a link to an example document if that makes it easier: https://drive.google.com/file/d/0B-2g_fp7BNE1VVdFNzBERUQ5aE0/view?usp=sharing
I'm looking for a way to make the "Subject Number" cell to update to the number of a subject that I click on, so that the display sheet will update to the corresponding data from the datasheet.
Cheers,
Sedicee