Previous Topic Next Topic

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 December 27, 2022 - Jul 7, 2015 at 11:37 AM
Hello,

I'm looking for a Macro/Formula to change value of a cell to (the row of the original cell I click on - 2). Is this possible?

Cheers all,

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0
Sedicee Posts 3 Registration date Monday June 29, 2015 Status Member Last seen July 6, 2015
Jul 2, 2015 at 04:47 PM
I have a title page and a sheet that displays data indexed from other sheets. I would like to be able to double click a title and have a cell that changes it's value to the number of the title so that the indexed display sheet will change it's information to what I what I clicked on.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jul 6, 2015 at 10:28 AM
Hi Sedicee,

Could you give an example with cell references and to what range it applies?

Best regards,
Trowa
0
Sedicee Posts 3 Registration date Monday June 29, 2015 Status Member Last seen July 6, 2015
Jul 6, 2015 at 04:53 PM
Thanks for your help,

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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel VBA copy and paste loop with logic condition
Yogibearv -
Yogibearv -

6 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Conditional formatting: change fontcolor based on another cell
wandanuila -
Ravi -

18 responses
Excel VBA - Change cell color based on value
Tandar -
ac3mark -

14 responses
Comparing columns and returning value
ll -
kittu -

35 responses