payslip

  1. M

    Picking and copying data from another sheet

    Please can someone help with a formula or VBA script. I have one workbook (payslip sort) that contains several sheets (one sheet per person that contains a breakdown of their pay) - I have another workbook (payslip macro) that contains a list of names in column A and next to their names in...
  2. J

    VBA code for emailing payslips from excel source file as pdf's to multiple employees.

    Hi I am rather new to VBA but have used Excel for some time. I have an excel file dump of employee payslips each week. All employees are contained in the one worksheet - structure of data is regular so a search for a key cell value eg "Earnings Summary" at the start of each payslip then create...
  3. K

    Need ideas to get column exact totals.

    Hello guys. I have made a sheet preparing payslips for emloyee however I am adding a rule to see if the employees is a Director then the calculations in each columns are done on cumulative basis. i.e. every employee has monthly LEL(1a) = 6032/12=503, LEL-PT(1b) = 2392/12=199 and PP-UEL(1c)=...
  4. V

    Payslip Calculator Excel

    Hi All, Does anyone know of an Excel Payslip Calculator available to download somewhere? Normally when I want to estimate my next months Payslip based on my Basic and my overtime being 1 month in arrears I use this website: https://www.uktaxcalculators.co.uk/payslip-calculator.php But ideally...
  5. D

    Auto Print Button with auto hide and unhide vba

    Hi, I'm new in VBA, I've been searching the internet to solve my problems in excel. I'm preparing a Payslip sheet which contains a Command Button which automatically prints all the payslips. The sheet contains salary benefits which other employees don't have. Let's say employee 1 is entitled to...

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top