Not sure if this is possible but I'll give it a shot...
The reports I run for payroll render an alphabetical sheet (with hundreds of employees) and their respective revenues earned in an adjacent cell.
Our payroll spreadsheets are broken out by office location, so the destination formatting is completely different than the report rendering.
Is there a way to copy from the alphabetical list and paste to the location-based list, with values essentially "finding" their necessary adjacent cell? Thus mitigating painless and unnecessary data entry.
I know the easy fix would be to have the source sheet match the destination formatting, but that's not an option.
Any help is appreciated
The reports I run for payroll render an alphabetical sheet (with hundreds of employees) and their respective revenues earned in an adjacent cell.
Our payroll spreadsheets are broken out by office location, so the destination formatting is completely different than the report rendering.
Is there a way to copy from the alphabetical list and paste to the location-based list, with values essentially "finding" their necessary adjacent cell? Thus mitigating painless and unnecessary data entry.
I know the easy fix would be to have the source sheet match the destination formatting, but that's not an option.
Any help is appreciated