(Solved) – Inserting Link into The Content of the Cell That Shows Information on Another Sheet

(solved)-–-inserting-link-into-the-content-of-the-cell-that-shows-information-on-another-sheet

I have an uncertain question that I want to ask.

Is it possible to insert a link (not website hyperlink) into the content of the cell that shows information on another sheet?

For example –> I have two sheets:
Sheet 1: Lending & Funding
Sheet 2: Company Information

On Lending & Funding sheet I have several information with 7500 data(s)/rows:
Column A: Client Name
Column B: Annual Sales
Column C: Interest

On Company Information Sheet I also have the same information:
Column A: Client Name
Column B: Annual Sales
Column C: Interest

Lets’s say, in Lending & Funding sheet, I have PT.Microsoft in column A, Annual Sales: $3.500.000, and Interest: 9% (They are in the same row).

What I want is whenever I click one of the contents in column A (PT. Microsoft for example), the Company Information sheet will appear like a pop up and shows the data of PT.Microsoft based on Lending & Funding information.

Is that possible to do so?

I’m really okay if macro excel code or vlookup/indexmatch formula is necessary for this kind of case. Maybe you guys can write me the code as well 🙂

Thanks in advance 😀

Leave a Reply

Your email address will not be published. Required fields are marked *