| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to export when printing
I need a macro that will export data from one worksheet to anther when it is
printed |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to export when printing
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel export Macro that does a filter | Excel Discussion (Misc queries) | |||
| help with macro to export data | Excel Worksheet Functions | |||
| excel xml export macro | Excel Discussion (Misc queries) | |||
| how do i create a macro to export a chart to powerpoint? | Charts and Charting in Excel | |||
| Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Linear Mode
