Ramballah
Active Member
- Joined
- Sep 25, 2018
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I am working in a sheet that whenever I click on a hyperlink, I then need to fill in the column next to it "Ja" meaning that I opened the hyperlink.
This has been very tedious for me especially since I got hundreds left to do.
Is there a way that when I click on the link in B2 for example that cell C2 will go from empty to "Ja"
I should mention that im using google spreadsheets for this one, but I can download the spreadsheet to Excel 365 if this is needed.
Here's an example.
Thanks in advance,
Ramballah
I am working in a sheet that whenever I click on a hyperlink, I then need to fill in the column next to it "Ja" meaning that I opened the hyperlink.
This has been very tedious for me especially since I got hundreds left to do.
Is there a way that when I click on the link in B2 for example that cell C2 will go from empty to "Ja"
I should mention that im using google spreadsheets for this one, but I can download the spreadsheet to Excel 365 if this is needed.
Here's an example.
Thanks in advance,
Ramballah
Last edited by a moderator: