Search results

Hi all excel ninjas... Please can someone help on this one.... Thanks for your time.

Hi erlindafb, considering Working time is in column C, Reported Time is in column D and the difference is calculated in column E, then use this formula in E column.. =IF(C6>D6,(C6-D6),(D6-C6))

Hi SirJB7, Thanks for the response. In the above code, you mention about "From & to" to pick up the pages for printing. However the situation here is when the excel sheet gets saved as PDF, the print area gets broken into multiple pages while it should come ideally as a single page. i.e...

Hi Deb, That was great !!!

Hi Amit, Thanks for the wishes... and same to you.. I have attached the reworked file... This now lists the emp code, emp name & the file path also.. However, i am still working on the formatting of the pdf file to get the payslip in a single page format.. I will post the file once i am...

Hi jorzgd6598 your link when tried give HTTP not found error.. Regards

Hi Amit, I am a busy at the moment.... I might need a couple of days.. Regards, Anil.

Hi Amit, Thanks for your encouragement... I will check into this and revert to you by evening today. For -- whenever I was trying to generating for the second time it was not working even after deletion the entire folder "Feb'12". -- in the Payroll sheet i have added a helper column in...

neat & cool !!!

Hi Amit, Kindly go through the file. It should be ready to use I have input comments in the code. https://skydrive.live.com/redir?resid=3E1509A4CCE38540!123&authkey=!AMnvq2WBGFkVD8I kindly let me know if it works at your end. Anil M

Hi Sachin.. if you have written code for last used as.. lastused = Range("B" & Rows.Count).End(xlUp).Row then use this.. set rng = Range("A1:A"&lastused) (just concatenate principle).. i am referring to the word "lastused" .. (you might have used something else)

Hi El, You can try this... Sub TeamFillOuts() If Range("C5") = "Go Ape" Then Range("C7") = Range("P9") Range("C9") = Range("P11") End If End Sub

hi gfmp123... Checked the file mentioned at the link... Don't seem to see any problem here.. Just need to tweak the formula a little bit... The formula in cell B2 is "IF(ISERROR(MATCH(A1,$C$1:$C$500,0)),"",A1)" shouldnt it be "IF(ISERROR(MATCH(A2,$C$1:$C$500,0)),"",A2)".. Mach was...

Hi weehawken, Could you attach a sample file.. that will be lot easier to understand your request. however, for stand alone point of getting the dynamic data range, you could use defining a name with offset formula... =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) The...

Hi Topbink You can use Index - Match combination to get the answer.. I have copied the data from your query as shown below in a single sheet. A, B, C, etc till J are the column headers as seen in the excel while 1, 2, 3 etc are the row headers. So "Date" is in cell A1. Column G is blank...

SirJB7, Just checked the solution !!! whew !!!.. I spent 20 minutes to understand the formula.. Understood.. But dont know if I will be able to replicate the same... Because understanding the formula is just 1 part.... Applying it is the game... Thanks