on paste, go to another worksheet
 

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

on paste, go to another worksheet
 

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

on paste, go to another worksheet
 

Tom,

Thanks for your advice. This macro will work perfertly if the user is using
crtl+v to paste. However, if the user other methods to paste (i.e. by
clicking on the Paste icon), then the macro won't work.

Do you have other suggestion so that when a user paste the information in
worksheet A using any methods he/she chose to, Excel will paste the info into
that sheet and go to worksheet B afterward.

Thanks,

Julia

"Tom" wrote:

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