I need a macro that will export data from one worksheet to anther when it is printed
S sriddle Dec 12, 2008 #1 I need a macro that will export data from one worksheet to anther when it is printed
G Gord Dibben Dec 12, 2008 #2 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
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 Dec 12, 2008 #3 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 Click to expand...
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 Click to expand...