Forum Discussion
Need help merging two different reports from the same program
Excel newbie here... Our payroll company said I needed to merge two separate reports generated by their program because they didn't offer the report that I want. A cost of labor forecast based o...
russpga , perhaps the easiest way is with Power Query - query Rates report, after that query Hours report, group it by and merge with Rates by Last/First name, add new column multiplying rates on hours and return back to Excel sheets.
If reports are in separate files it will be similar and, I guess, more flexible - you create the merged report for such two files, after that only substitute them with new data but same names.