[HELP] Mouse over in excel - Seeing cell from Worksheet B in Worksheet A when mouse over

I have two worksheets A and B. Hovering ON a cell of the spreadsheet A I need to appear as comments or similar, a value or values​​, that is (are) given in (s) cell (s) of Worksheet B. Does anyone know how to do this? I,m noobie in excel and don't know VBA. Please heeeeelp ! Thanks in advance.

If I recall I do not believe there is an event that triggers off mouse hovering over a cell (although you could probably write a hack and slash way to do it). The easiest thing would probably be just to create comments for each cell and have the comments set to the values of the cells in worksheet B. This all of course depends on scale of your workbook/data - post a sample and I'll see if we can figure something out.

Thanks for your feedback, but the volume of data is too large to use comments. I Cells need to connect A to B cells to have an acceptable result.

how many cells are you talking? Even a couple thousand would only take like 30 seconds to trigger/run through at most.

Please, I need answer to this question. The question is simple. The answer is complex, I know.

Olá Marreco,

Então ... tenho duas planilhas em pastas diferentes. A primeira planilha tem os números dos apartamentos de um prédio. Na segunda planilha eu tenho as metragens de cada apartamento. O que eu preciso é que apareça a metragem do apartamento que está na planilha B, como se fosse um comentário (ou algo parecido com comentário), quando eu passar o mouse sobre o número do apartamento que está na planilha A. Ou alguma coisa como... Aparecer como cometário (ou similar) na célula A5 da planilha A, o conteúdo da célula E5 da planilha B.

Obrigado desde já.

Renato
[email protected]

For better explain see this images: http://zecapoa.tumblr.com