I want to calculate my own payslips with the hours I worked including overtime, holiday bonus, annual lv etc. I've made it where I have one payslip per workbook but my greedy self now wants all payslips in the fiscal year put into one [with automatically updating payslips]. I have an idea of what I want to do but the execution is challenging.
Hi, well, greedy youwithout an idea how your workbook looks like I don't know.
I suggest you attach a sample with some dummy data unless you want us to see how greedy you are
I don't use Office 365 but this will be basic Excel It might be possible with only formulas but it might also be necessary to write a macro for that.
Show the workbook with what you have and the idea of how you want it
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I'm not sure how to upload files on this forum yet. I'm still quite new to vba in general as well.
Right now my payslips are organised like this "component" column, "this pay" column and "ytd" column.
YTD is the total of all past "this pay" in the current fiscal year. So I want to use something like
But this is with excel vba format
Please Login or Register to view this content.
Last edited by rad042; 10-29-2021 at 06:18 PM.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
This is what 'Sheet1' looks like
Pay Period: 1 Pay Date: x
From: 03/04/2021 To 06/04/2021
Component This Pay YTD Hours Rate
Ord 250 250 10 25
Perm1.5 0 0 0 37.5
Gross 250 250
This is what 'Sheet2' looks like
Columns A & B are what I'm focused on
Pay Period Date Shift Hours
1 03/04/2021 AM 4
1 04/04/2021 na 0
1 05/04/2021 na 0
1 06/04/2021 na 0
2 07/04/2021 PM 3
2 08/04/2021 AM 4
Ok I've uploaded the file
Take a look at the formula
Please Login or Register to view this content.
I made it a little more interactive, both date fields are data validation lists and the period is calculated automatically based upon your entered date in B3 and next to BANK the end period based upon the last entered date
All with formulas, no macros
Have fun playing around with formulas and Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks