hi all.
i currently have an excel file with 2 sheets.
Sheet 1 is a database.. is Col A date, Col B name Col C price. Col D is customer number
In sheet 2 i have a prefilled letter, that once i input the customer number, it auto completes the remaining fields.
This part is done and easy.
The hard part is i do about 100 of these at a time.. and the output needs to be in a jpg file!!! EEK!
currently what i do, is print preview, screen shot, ms paint, select, copy, paste into new paint file, save as customer number..
this is aweful... although i've gotten quick at doing it, surely theres a way to 'batch print' or something?
any ideas?
thanks
i currently have an excel file with 2 sheets.
Sheet 1 is a database.. is Col A date, Col B name Col C price. Col D is customer number
In sheet 2 i have a prefilled letter, that once i input the customer number, it auto completes the remaining fields.
This part is done and easy.
The hard part is i do about 100 of these at a time.. and the output needs to be in a jpg file!!! EEK!
currently what i do, is print preview, screen shot, ms paint, select, copy, paste into new paint file, save as customer number..
this is aweful... although i've gotten quick at doing it, surely theres a way to 'batch print' or something?
any ideas?
thanks