Home

spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-765050%22%20slang%3D%22en-US%22%3Espreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765050%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20tell%20me%20an%20easier%20way%20to%20continue%20spreadsheets%20(%20for%20payroll)%20month%20to%20month%2C%20other%20then%20copy%20and%20paste%20and%20adjusting%20formulas%20one%20by%20one.....which%20is%20inefficient%20and%20very%20time%20consuming....especially%20when%20new%20employees%20are%20added%20to%20existing%20spreadsheets....help%20please%2C%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-765050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Espreadsheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765083%22%20slang%3D%22en-US%22%3ERe%3A%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765083%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379150%22%20target%3D%22_blank%22%3E%40jsam1_%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20easiest%20way%20is%20to%20make%20a%20separate%20excel%20file%20having%203%20sheets%20for%20each%20month.%20Put%20all%20permanent%20data%20(Name%2C%20DoJ%2C%20DoB%20or%20contact%20details)%20in%201st%20sheet.%20Data%20in%20this%20sheet%20will%20remain%20same%20for%20any%20given%20month.%20Whenver%20a%20new%20employee%20comes%20just%20update%20a%20new%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%202nd%20sheet%20keep%20such%20data%20where%20probability%20of%20change%20is%20not%20very%20frequent.%20(For%20instance%20Employee%20position%2C%20grade%2C%20salary%2C%20benefit%2C%20marital%20status%20etc.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReserve%20third%20sheet%20for%20all%20calculations%20based%20on%20data%20stored%20in%201st%20%26amp%3B%202nd%20sheet.%3C%2FP%3E%3CP%3EOnce%20payroll%20for%20any%20given%20month%20is%20finished%2C%20Save%20As%20the%20same%20file%20with%20other%20name%20for%20the%20next%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20you%20may%20share%20sample%20data%20so%20that%20a%20small%20payroll%20file%20can%20be%20designed.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
jsam1_
Occasional Visitor

Can anyone tell me an easier way to continue spreadsheets ( for payroll) month to month, other then copy and paste and adjusting formulas one by one.....which is inefficient and very time consuming....especially when new employees are added to existing spreadsheets....help please, thanks

1 Reply

Hi @jsam1_  

 

The easiest way is to make a separate excel file having 3 sheets for each month. Put all permanent data (Name, DoJ, DoB or contact details) in 1st sheet. Data in this sheet will remain same for any given month. Whenver a new employee comes just update a new row.

 

In 2nd sheet keep such data where probability of change is not very frequent. (For instance Employee position, grade, salary, benefit, marital status etc.)

 

Reserve third sheet for all calculations based on data stored in 1st & 2nd sheet.

Once payroll for any given month is finished, Save As the same file with other name for the next month.

 

Alternatively, you may share sample data so that a small payroll file can be designed.

Thanks,

Tauqeer