Macro to export when printing

S

sriddle

I work for a pharmacy. We use a worksheet to print labels for drugs. I need
a macro that will export info on the label worksheet to another worksheet to
be used as a database. I need the data to export when the label is printed
as it is not saved. The label is overwritten by the next label after it is
printed.

Any help would be greatly appreciated.
 
Top