I was using Export as well. The problem was that there might be a handful of rows and several columns spaced across the table with gaps between to improve handling, and I had some complaints that the exported pictures were problematic to view on older or smaller screens (some customers apparently view on mobile devices), so I was moving all those rows and columns closer to make shorter/narrower proof pictures. Couple that with changing the color coded fill (used to engrave one column at a time for faster engraving time due to not skipping over the gaps), and it was becoming a time consuming chore to create the proofs.
So after asking here and finding, to my surprise, that I apparently am the only person who does proofs this way, and that no one had any particularly good solutions other than one commercial macro package that looks like something I'll probably get eventually for other reasons, I rolled my own macro to do the job. I actually just finished it yesterday, with the error checking and layer manipulation (engraving, registration, product image reference layers that may be visible or invisible, editable or not, printable or not, depending on what phase of the project I'm in) that I glossed over initially, and it works a treat. A hot key or a custom button on the tool bar both let me go from a finished, color coded job file to simulated product proof picture in a single key stroke or mouse click, and it's undoable with another single keystroke or mouse click.
It's been a while since I've done any coding, but there are so many tutorials and bits of example VBA out there that I was able to glean what I needed and work out a neat solution. There probably are even better ways of coding it, but it finishes before I've let off the key or mouse button so plenty good enough! Now I just need to find that self-certificate creator so I don't get that annoying "This file contains macros, do you want to enable or disable them?" security warning when I open the template to create a new engraving job file!