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

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

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

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

Jennrl wrote:

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

--

Dave Peterson