Macro to export when printing

S

sriddle

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

Gord Dibben

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
 
S

sriddle

Gord Dibben said:
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



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top