I code for a company that uses the EPIC EMR system. We are trying to go paperless in order to start working from home. Currently, The girls that reconcile our batches to code, run a report in EPIC and have to copy and paste the information from that and create an Excel spreadsheet for us to code from. As you can imagine, this is very time consuming and with as quick as we code batches, it seems like this process is a waste. I’m wondering if there are any Macros I can run in Excel that will pull the information over in a neat spreadsheet or if there are any other tips or tricks anyone knows of that might help speed up the process or be a little easier to compile all the information.

Thanks for your help!