Julie,

Try:

Sub myPaste()
ActiveSheet.Paste
Application.CutCopyMode = False
Sheets("Sheet2").Select
End Sub

Then in Excel, go Tools, Macro, Macros....
Select myPaste from the list of macros, hit the Options... button,
and assign control v as the shortcut key.

Then anytime the user uses control-v to paste, it'll paste and then
move over to Sheet2.

--Tom.

Julie L wrote:
Please help! I want to write a macro so that whenever I paste some
information in worksheet A, it will direct me to worksheet B.

Is there any way to do this in excel?

Thanks,
JL