Hi excel guru,
Need some help, i need to run a project to copy data (sales & outstanding) on daily basis and later print the summary range as jpeg file as output.
I have figured out how to copy and print them, now i am stuck in the process of how to print them in bulk at one go, ie. let say i have 40 accounts to process daily, i want the VB to match the account# in tab sales & outstanding, and output each of the 40 accounts as individual jpeg file.
i have attached the file here for better understanding
where am i now and cracking my head, would appreciate you help.
Thank you.