Macro to export when printing

S

sriddle

I work for a pharmacy that uses a spredsheet to print labels. The label has
drop down menus for the doctor, drug, patient etc. I need to export the data
for each individual label as it is printed, because it is not saved. Each
label overwrites the next. I want the data for each individual label
exported to another worksheet for use as a database. Any help would be
appreciated.

Thanks
 
Top