View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
sriddle sriddle is offline
external usenet poster
 
Posts: 8
Default Macro to export when printing



"Gord Dibben" wrote:

Which comes first?

You want to copy data to a new sheet then print the new sheet?

You want to print a sheet then copy all or some data to a new sheet?

Whichever the case...........try the macro recorder and see what you get.


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 12:50:01 -0800, sriddle
wrote:

I need a macro that will export data from one worksheet to anther when it is
printed


I want to print the label then export about 5 lines on the label to another worksheet