Preparing a commission worksheet from an excel spreadsheet

mel - Aug 17, 2016 at 02:53 PM

I am a payroll specialist. Every two weeks I run a report for all employees who have funded loans. I copy that information into another workbook that is separated by tabs for each employee. This is how I am able to print out commission worksheets for each.

I would like to simplify the copying and pasting by importing the report right into this workbook, where the funded loans are imported into the correct employee's tab. Is this feasible, and how?

I already know how to import excel into a word document for letters and such....which is easy.