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

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies