write a copy/paste from one workbook to another in a macro

[Jennrl]

I do this frequently and would love to have it written in a macro. have tried
everything i can think of

 

[Dave Peterson]

Have you tried recording a macro when you did it manually?