1. B

    VBA for Payroll and statutory deduction

    I am new to VBA. I will need your assistance in building a VBA the will automatically import and perform the tax calculations. Thank you and I will really appreciate your assistance.
  2. A

    Payroll employee exit query

    i am preparing payroll sheet. there is mastersheet where all employee data available and there are 12 sheets for attendance and salary. if any employee leave the job his data wont be showup in further month in aatendace and salary sheets but his past month data must be there for records.. how...
  3. J

    Formula to calculate earnings based on multiple factors

    Hello. I use this board a lot to get answers to my questions but this is my first post so please let me know if I miss anything important. I am trying to calculate some payroll figures and running into some trouble. I know this is a task that seems redundant, well it is, but we are working...
  4. R

    picking up same info from different columns

    Hi I have a spreadsheet that comes every month with a lot of payroll data on it. I need to update a master sheet that holds summary details each month. My problem is that the data in the columns from the payroll spreadsheet can be different each month eg month 1 col D may have OT1 but next...
  5. S

    [VBA] Copy/Paste Values to New Workbook and Separate Tabs

    So I have somewhat of a complex requirement that I need some help with in VBA. I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook...
  6. leopardhawk

    Need expert advice with difficult formula

    Trying to piece together a formula that will combine a bit of text with COUNT results from a worksheet called 'payroll'. Perhaps I should start with what I want the finished result to look like. The formula, which is on a worksheet called 'income_analysis', would return the following...
  7. R

    return column header for each value occurrence in a table

    Hello, I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada <tbody> USA Spain China Canada Mexico Janitor Payroll Janitor HR Manager Operator...
  8. T

    VBScript - Effecient Close Of Excel Workbook and Application

    Hello all, I am running a VBS macro in our ERP that opens a target Excel Document and populates the form with data from a workbook. The program works but the execution time is roughley 1 and a half minutes. I placed some MsgBox's throughout the script to see where the lag was comming from...
  9. P

    VBA remove decimals

    Hi all, I would like to use a VBA code so that to clear the numbers’ decimals which contains space before comma e.g. 26 ,7 should be 26 Therefore that, the code should run through col. “C4” : “O” and rows down. Please see below an extract of original data and the expected result. Thank you...
  10. C

    Conditional format date if it matches two conditions

    I have searched the web for a solution to my question with no luck. Here is my issue: I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates. I need to...
  11. E

    Allocate costs on a monthly basis

    Hi all, I tried looking for an answer myself (or here), but I just can't get it to work. Hopefully the answer is understandeable for a non-IT guy (finance background)... :-) So the problem: We have about 100 employees working on our payroll and we want to allocate their individual cost to...
  12. cricket1001

    Confused on how to do a formula for my payroll workbook

    I have a payroll workbook that has 26 payroll worksheets and an OT Totals worksheet at the end. I'm trying to figure out a formula in the OT Totals worksheet that will find an employee's last name in each worksheet and total their Reg OT. Last year I just made a formula by going to each...
  13. J

    VBA Code to Download Password Protected Excel File - Server Blocking Request

    I am trying to use the below code to download a list of daily reports from password protected sites. The server seems to be blocking the request. I have no issues when manually logging in to download each report. I am using Excel 2013 and not positive that this is the correct WinHTTP...
  14. E

    Help with formula for simple payroll

    <tbody> weekly salary ee er weeks salary 200-339.99 11.9 23.8 4 340-449.99 17.4 34.8 450-609.99 23.3 46.6 610-759.99 30.1 60.2 </tbody> hello so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1
  15. P

    Revise numbers

    Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...
  16. R

    Overtime payroll sheet nightmare!

    Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...
  17. Z

    Formula for Counting No. of Hours Worked Based on Se Schedule Excluding Time Outside of Schedule

    Hi, everyone. Sorry if the title is kinda vague, but what I was trying to do is coming up with a formula for computing the number of work hours for each employee based on their schedule against their timestamps. Then, also compute their lates and absences. Here's how my tables would look like...
  18. M

    Apply background fill color to a range based on cell value

    We use alternating background fill color in columns A-G as a visual reference to distinguish between rows with certain payroll date values stored in G. Currently, we have 2 macro buttons that each apply 1 of the colors. I'd like to incorporate this functionality into the vba language, so we can...
  19. B

    Comparing totals via conditional formatting

    Hi, I am looking to utilize conditional formatting to color code a set of totals compared between 2 payroll systems. The one payroll system pays by the minute and will have the format 37:47 for example to show 37 hours and 47 minutes worked that week. The other payroll system rounds to the...
  20. A

    percentage round up to nearest decimal point with range

    <tbody> Salary 11% Payroll Website Result RM 3460 RM 380.60 RM 381.00 RM 3470 RM 381.70 RM 383.00 RM 3480 RM 382.80 RM 383.00 RM 3490 RM 383.90 RM 385.00 </tbody> dear all, I'm doing a manual excel formula payroll therefore I faced an issues that the calculation of 11%...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back