Connecting Two Sheets by Cell Value

Reb

I have two sheets - one for contract info and one for billing info. I'd like to be able to click on a row (or field/cell) in one sheet and be taken to the respective customer's info in the other sheet. I don't need to do calculations or inbound or outbound links. I only need to click on Customer X contract info and be taken to Customer X billing info in the other sheet, and vice versa.

So, for instance, something like "click here to find Customer X on Sheet 2" . . .

Thoughts?

Andrée Starå

Hi @Reb

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could maybe use a report instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!