Pulling information when a cell is selected.

Hey Guys,
I was hoping someone could help out with an issue I'm having in Excel currently.

I'm trying to copy data from another sheet to a cell when another cell is selected. This is what I have so far:

Please Login or Register  to view this content.

But right now if ANY other cell has the same data as "C6" it will run the actions.

Hi

Presumably you only want to action this for C6 so try

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

rylo

This fixed the issue right up, Thanks!