Thread: Efficient alternative to repeatedly entering data manually in Excel
View Single Post
 
Old 09-24-2018, 03:32 PM
sanders456 sanders456 is offline Windows 8 Office 2013
Novice
  
Join Date: Sep 2018
Posts: 1
sanders456 is on a distinguished road
Default Efficient alternative to repeatedly entering data manually in Excel
I have several payroll reports on different spreadsheets that I need to edit.

One of the columns has Employee ID Numbers, and another column has Unit Pay Rate. I need add the Unit Pay Rate Based on the number. The thing is, the employees and pay rates are mostly the same from pay period to pay period.

Is it possible to do this in a more efficient manner than manually adding them all?
Reply With Quote