Payroll Save As PDF Using Macro?
Jun 17, 2014
I have a problem in saving multiple pdfs from excel. I am posting a sheet here. First sheet has the employee details. Second sheet have the template for payslip. My aim is to save pdfs of templates of all the employee in the list using a macro.
currently i am doing it as
1. In sheet 2, I lookup each employee using the serial number of employees at the top left corner cell of the template.
2. Once the details are updated in sheet 2 i save it as pdf in my desktop.
The problem with recording macro and looping is that the pdfs are overwritting and the last pdf alone is saved. i could not find how to change the pdf name for every loop.
View 2 Replies
ADVERTISEMENT
Jul 7, 2007
I have created a spreadsheet to work out deductions from gross weekly pay to give a net amount. I would like to be able to get from a net amount back to a gross amount but am unsure of how to do this.
Deductions are tax and national insurance. A person has a tax code for example 885 meaning they can earn up to 8850 a year before being taxed of 8850/52 a week so anything after 8850 is taxable. There are two tax rates (10% )and (18%). The band for 10% is 10500 per year or 10500/52=201.92 a week. This means any taxable pay above 201.92 is taxable at 18%.
To work out National insurance deductions for an employee, weekly gross amount- 100 x 10% giving the National insurance to be deducted. So Gross - Tax - National Insurance = Net amount.
Attached is a spreadsheet I created to work it out. Firstly does this look okay? Secondly is it possible to get back to the gross amount given ONLY a net amount and a tax code?
View 4 Replies
View Related
Jan 12, 2007
I am having a little trouble with IF. My pest control sales people are paid on straight commission. In addition to paying them a sliding percentage of the total contract value I pay them 50% of everything above $100 they charge on the initial service.
calculating these formulas?
Attached is the payroll document.
View 11 Replies
View Related
Nov 18, 2008
I am trying to calculate payroll. I have 2 columns where regular hours and overtime hours are manually inputed. They are then multiplied by their respective pay per hour columns to come up with regular and overtime pay. The next column adds these to get total gross pay. That gross pay is then multiplied by the FICA and FICA Med factors to figure those taxes(2 different columns). I then have a column the adds all deductions to get total deductions(Fed,FICA,FICAMed,St). The last column subtracts total deductions from the gross pay column to get net income. My problem is the net pay column is $.01 off sometimes.
I think what is happening is I obviously have all columns in dollar amounts with 2 decimal points. Some function columns have multiple decimal points in the answer and then are only showing the 2 decimal points. When those columns are used in the next equation, instead of using the dollar amount that is showing with 2 decimal points, it is remembering the multiple decimal points. This is resulting in being a penny off when I get to the end. How can I get the equations to use what actually shows in the columns(2 decimal points) instead of remembering multiple decimal places?
View 2 Replies
View Related
Mar 7, 2014
Each payweek I receive about 600 records some with duplicat names if an ee works overtime. I then look at previous payroll and extract a given account code. Because some ee's work overtime the rows do not always synchronize in count or names.
Any BEST lookup function? Or BEST tool? Is access a more logical option?
View 1 Replies
View Related
Aug 2, 2006
We are working on a spreadsheet that would project what our labor cost would be for next week. I need some help in figuring out how to calculate overtime when an employee reaches 40 hours.
View 9 Replies
View Related
Sep 6, 2012
I'm trying to make a macro check if a file has been saved (ever). If so I want the macro to do a regular save (with already esatablished filename and location) before it proceeds with the rest of the macro. If the file hasnt been saved (if it runs from a new workbook) then I want it to pop up the save.as dialog, so that the user can choose the name and location of the file before the macro continues .
The macro itself is saved in personal.xlsx.
View 1 Replies
View Related
Oct 22, 2008
I'm trying to have a macro that opens the save as window, places the name in cell f5 and then allows you to save the workbook with cell f5 as the filename. I have managed to get the save as window to come up and the cell f5 as the name, but when I press save is doesn't. Here is what I have (also, is there a way to direct this to a specific folder).
View 4 Replies
View Related
Jul 30, 2013
Sso if you've done payroll before, you may have run into the 53rd instance of a payroll week. Today I've been editing my payroll template to compensate for this occurrence and I've almost got it complete but of all things to mess up on me, a hyperlink is the problem.
I have a legend where I can see all of the payroll week periods, the amount paid, PTO used, etc. And ALL of my payroll sheets are named "Payroll #1", "Payroll #2" ... "Payroll #52" and have a cell on my legend that hyperlinks to cell $A$1 of the corresponding sheet. But when I went to add in this 53rd week, the hyperlink has decided not to work. It will work if I name it anything else, and it will work if I take the # out of the name it will work, but I want to have the # in the sheet name because all other 52 sheets are named thusly and I would rather fix this one link than go back and replace 52 other working links and risk breaking something else.
Here is an example of one of my working links:
Screen Shot 2013-07-30 at 5.41.42 PM.png
I created the Payroll #53 the same way:
Screen Shot 2013-07-30 at 5.42.50 PM.png
But it always resets to this as soon as I try using the link:
Screen Shot 2013-07-30 at 5.42.15 PM.png
And pops up this error:
Screen Shot 2013-07-30 at 5.47.35 PM.png
I do have a VBA Macro that hides both that sheet, and the row referencing Payroll #53 on the legend by using a checkbox. I'm not sure why the # sign is making everything so difficult when there are 52 other hyperlinks that use it also. I tried deleting my macro to see if that was part of the problem but it still refuses to properly create the hyperlink. I also tried rebooting to see if that was part of the problem but it wasn't.
As a side note, this particular cell will not link to any page with a # in the name.
Screen Shot 2013-07-30 at 5.45.51 PM.png
I tried creating the hyperlink on a Windows based machine (since Microsoft is native to the OS after all) and it worked. So it must be a bug or something in the Mac version.
View 1 Replies
View Related
Mar 6, 2013
I have multiple departments I need to keep track of multiple numbers with. For example, I need to see the cost of payroll for last fiscal year, vs this fiscal year and have excel show that as a gain (bad) or shrink (good).
I need to track sales this FY vs last FY, obviously, a gain is good and shrink is bad.
Finally, I need to track d&d goods this FY vs last FY.
Where I'm getting held up is, for example last year's payroll was 12000 and this year's is 12500 but next months is 11000 this FY vs 13000. How do I get excel to figure out that payroll decreasing is good and not just do simple subtraction or negative addition thereby allowing me to just plug the numbers in and excel figure out if what I'm throwing at the cell is bad or good comparing to last year?
Also, if I could figure out the if/then to show positive numbers green and negative numbers red that would be quite awesome too.
View 1 Replies
View Related
Feb 1, 2007
I need to determine federal tax withholding from gross pay.
If gross amount (for S-0 = single no dependents) is
Over.................But NOT Over............Then Subtract.........And multiply
$0.00...............$195.00.....................$5 1.......................10%
$195.00............$645.00.....................$99 .......................15%
$645.00............$1,482.00..................$351 ......................20%
$1,482.00..........$3,131.00..................$447 ......................25%
$3,131.00..........$6,763.00..................$849 .....................30%
If gross is $400 then what are the total taxes taken out? Could someone please provide a formula?
I tried this one: =IF(M10
View 9 Replies
View Related
Feb 9, 2007
I currently have an Excel payroll extract that populates a start date and end date via the calender control 11 user form.
What I have found out is I need to inject some sanity to this application. I can not have users select days that are outside of a pay period.
The users should only be able to select the first or the 16th of the month for a pay period start. Then they can only select the 15th or the 28th/31st for the pay period end.
What I am trying to do is have them select the month and the pay period start date, then the end date would automaticly be selected. But I don't want to have to create a bunch of loops to counter for the differing month end dates or leap years.
View 9 Replies
View Related
Jan 17, 2010
I have a macro that copy one sheet of the Active workbook and sends it via email.
I need to add a code in this sheet so when one opens it from the email, with a command button to be able to save the file to specific, fixed folder on the local network with it’s original file name.
View 10 Replies
View Related
Dec 3, 2013
I am trying to attempt to create a payroll spreadsheet with certain aspects and with multiple worksheets. so what im trying to accomplish is this
1/ on my main worksheet would have the payroll template there would be 2 columns (1) would be "routes" (2) would be the dollar value of that route.
2/ i want to be able to pick from a drop down list in colume (1) which will have various routes such as A,
B, C, D, E etc
3/ once i have selected a route in colum (1) i want to have the dollar value that is associated to that route to show up in column (2)
ex/ route A worth $1
route B worth $2
create a dropdown list but thats about it, i have not been able to link any values together.
View 11 Replies
View Related
Jun 18, 2014
I have a payroll spreadsheet and I want to highlight cells that have hours entered for vacation. For example, in cell E4 I put the job name which is "VACATION" and in cells G4 through M4 I put the hours in for each day. (G4 is Monday, H4 is Tuesday, etc.)
I tried to put a conditional formatting using the following formula ="IF(E4=""VACATION"")" then I chose the fill color however it is not working.
View 3 Replies
View Related
Feb 5, 2007
My spreadsheet has 32 worksheets, I've recorded a macro to do the job "save, save as with specific name", but what I want is, when save as, I wanted the file name increase in one number, and the date in a specific range "H8:J8" the date should be the next saturday.
here is part of the code.
Range("D11:J65").Select
Selection.ClearContents
Range("J44").Select
Sheets("NsFri").Select
ActiveWindow.SmallScroll Down:=-12
Range("A12:A21,D12:I21").Select
on this example I want the file saved as "PrA4W05.xls", being the next week "PrA4W06.xls", and so on.
and on "H8:J8" the next saturday.
View 9 Replies
View Related
Aug 15, 2014
I am trying to create a macro to run from a form button, within a report, to save a file to a variable file path and name depending on the date value in cell B5.
The format of B5 looks like - 13/08/2014 16:39
The file path has folders for each year in format "yyyy" with each year having sub folders for each month in format "mm".
The file name is just the date only and is formatted "dd.mm.yy" e.g. 13.08.14
I have tried the code below in various permutations but always end up with an error - Method 'SaveAs' of object '_Workbook' failed.
[Code] ......
View 3 Replies
View Related
Oct 16, 2009
I am trying to make a save&close workbook macro.
I found several examples on google, but unfortunatly it conflicts with another macro I use for forceing users to enable macros (hide all sheets except one if macros are disabled).
The attached file is an example contaning the save&close code and the show/hide sheets depending on macros enabled.
If the file is opened with macros disabled then only one sheet will be visible.
If the file is opened with macros enabled other sheets are visible.
The problem if that this code uses a custom save, witch makes the save&close not save... (in module1 and in ThisWorkbook)
The pourpose of the save&close is to make sure some users don't forget the excel open and thus block access to it. So if a certain idele time passes excel has to save and close without any confirmation messages.
View 10 Replies
View Related
Nov 30, 2011
I have a macro that saves each sheet of my workbook to PDF's. I have a macro that runs prior to the save macro that filters each sheet and hides rows I do not need printed.
I simply use a formula to show a 1 in column H.
What I would like to do is sum let's say rows 5:58 and it H59 is below let's say 5 that sheet is not saved as a PDF.
I looked for awhile for a if.then macro that might solve my question, did not see anything that fit.
View 2 Replies
View Related
Nov 14, 2006
I want to specify a button that have the function of prompting the user to save the file as new file name. I tried to do the record macro, but I think it's not working as I wanted to. Can any expert teach me the code? As I was creating a standard form (excel file), I don't want the users to overwrite the current file name.
View 9 Replies
View Related
Jul 10, 2008
I work with a read-only template, and desperately need a macro that would save it as a workbook, and every worksheet of it as a separate txt file, then close the whole thing.
I will be re-using that workbook it just saved again, and I want to have the same macro there as well (that it should save my workbook as workbook and every worksheet as a separate txt file).
View 9 Replies
View Related
Mar 27, 2009
In My sheet I would like to check to make sure col 15 is true before going through the process of adding the contents of each row from col 6 - 10 to column 5. (Col 5 could already contain values)
This is my
Private Sub Workbook_ThisWorkbook(ByVal SaveAsUI As Boolean, cancel As Boolean)
BeginRow = 8
EndRow = 87
ChkCol = 15
BeginCol = 6
EndCol = 10
For RowCnt = BeginRow To EndRow
If Cells(RowCnt, ChkCol).Value = True Then
For RowCnt = BeginRow To EndRow
Cells(RowCnt, 5).Value = Cells(RowCnt, 5).Value + Cells(RowCnt, ColCnt).Value
Next ColCnt
End If
Next RowCnt
End Sub
View 9 Replies
View Related
Apr 3, 2009
when I record a macro in excel and assign it to a command button, it does not save and have to keep recording it when I open up the workbook again. I notice when i close out of the script editor after saving, the debugger box does not pop up when on most occassions it does.
This does not happen all the time, just some of the time which makes absolutely no sense to me. I have double checked to make sure the module is saved under the current workbook, i have tried saving the script to my personal macro workbook (XLSTART), i have tried saving the file on a shared drive and my desktop, but nothing seems to work. The workbook is not protected and am at a complete loss.
View 9 Replies
View Related
Aug 8, 2009
so i can save the macro and try (usually unsuccessfully) to change it.
excel 2002
View 9 Replies
View Related
Jul 14, 2006
I have a 4 sheet workbook. 3rd and 4th are hidden running formulas. These hidden sheets have macros that creates a new file from each (the macros deleted unwanted rows in the files, then save as a seperate file and format [.mht and .csv respectively]). Everything functions properly, except the problem is, I need to make sure the changes to sheet 1 are saved, but when I save the file, the changes to 3 and 4 are saved, and I lose the formulas.
View 4 Replies
View Related
Jan 17, 2007
I would like to run a macro AFTER the user has saved the workbook. I can only think of manipulating the before save event but dont know how to do that.
View 9 Replies
View Related
Apr 10, 2014
I'm trying to get a macro to run when the user presses the save button. I have the following code:
[Code] .......
This code is supposed to apply the TRIM function to every worksheet in the workbook when the user presses save, and the saves the results. I understand the Private Sub bit is the code to have the macro run during the save, but for some reason the macro itself isn't actually running. I'm not getting any error message, its just that the cells which should have the TRIM function applied to them aren't being corrected.
View 4 Replies
View Related
Feb 27, 2014
I need a macro that will save the range of cells with values as a pdf and saved as the sheet name. I have a macro that does a print preview function based on the cells that contain values. It works great, but instead I just need this to be saved as a pdf.
This is what I have:
[Code] .....
View 2 Replies
View Related
Jan 2, 2009
I have quite a few macro's saved on my personal xls file. Anyway for me to save them with the current date to a specific folder?
e.g. MacroNameDate.bas
View 5 Replies
View Related
Jul 8, 2009
I need a before save event macro in excel that will check if sheet1 cell ref A25 = zero. If it isnt zero I want a msgbox to say "Does Not Equal Zero" to pop up, if it is zero then I do not want a msgbox displayed. In both instances I still want the file to be saved.
View 5 Replies
View Related
