Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
Sheet 1 Column G contains cells filled either red, yellow or green.
Sheet 1 Column H contains text.
My desired outcome is:
Be able to copy text from any cell in Sheet 1 Column H to any cell in Sheet 2 Column E, then
Click on the newly-copied text in Sheet 2 Column E.
Excel will then search Sheet 1 Column H and find the identical text (search up to 255 characters to prevent code mismatch errors)
The result will then create a link in Sheet 2 Column E back to the original cell in Sheet 1 Column H and will also now have the same red/yellow/green cell fill as the adjacent cell in Sheet 1 Column G.
I hope this is clear and I'd be over the moon if a solution can be provided.
Thank you!
Sheet 1 Column G contains cells filled either red, yellow or green.
Sheet 1 Column H contains text.
My desired outcome is:
Be able to copy text from any cell in Sheet 1 Column H to any cell in Sheet 2 Column E, then
Click on the newly-copied text in Sheet 2 Column E.
Excel will then search Sheet 1 Column H and find the identical text (search up to 255 characters to prevent code mismatch errors)
The result will then create a link in Sheet 2 Column E back to the original cell in Sheet 1 Column H and will also now have the same red/yellow/green cell fill as the adjacent cell in Sheet 1 Column G.
I hope this is clear and I'd be over the moon if a solution can be provided.
Thank you!
Last edited: