Macro to export when printing
Did you try the recorder?
Gord
On Fri, 12 Dec 2008 15:29:01 -0800, sriddle
wrote:
"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
|