Search results

@ Luke, Thank you so much for your input.You have exactly delivered what I was looking for. Just a bit of tweaking in the code to suit my need and the file would be good to go. @Kaushik, Your template goes that extra mile to have this auto send option which is amazing. However there...

Hello Narayan, This is absolutely perfect. Just dumped the yesterday's raw data in the file and the script worked like a magic displaying the final output values with "ZERO ERRORS". Thanking you is the least way of showing my gratitude for your help. You made my day, Narayan. This...

Hello Luke, Considering my skill level of VBA scripting, this is something beyond my brains. The 1st link is a basic one which needs manual intervention for generating an auto email and the 2nd link is rocket science,too hard to crack Unfortunately both the links couldn't cater my need...

Thanks for sharing the links, Luke Will review and get back to you if any further assistance is required Raja

Hello Luke, Much Thanks for your response. Option 2 (Auto Open) sounds good to me. Furthermore, would it be possible to auto generate an E Mail to the respective new joinee on the day before his joining date. I would be including the E Mail ID details in the report? Thanks in advance, Raja

Hi Narayan, You make me smile each time you revert to my post :) A big big thanks for your commendable support. Your inputs are noted and would be implemented as and when required Awaiting your revised template. Regards, Raja

Hello All, I have a file which talks about the data of the new recruitments along with their joining dates. Can I have an option where there would be some kind of "ALERT" poping up exactly a day before the joining date of the employee even when my report file is inactive/closed state...

Hello Narayan: Thank you so much for getting this done. This is phenomenal. Appreciate your work & support. I'm very pleased with your resolution. You almost got the report perfect however missing out only on few points as mentioned below: 1) First Swipe In & Last Swipe Out are accurate...

Hi Deb, Now this is what I say complete "fool proof" stuff. Today I learnt a lot from you. Many Thanks for sharing this valuable inputs. Regards, Raja

@mahaveer: Am not sure but I think that the shared file is not the relevant one to this post. Could you please re check? Apologies if I got this wrong Thanks, Raja

Hello Debraj, Your first remedy [=ISNUMBER(SEARCH(BPC,A1))] has the done the job effortlessly for me And in regards to the usage of filter option, I seldom use it because when I apply filter to a data and copy the filtered data and paste it in a different sheet, I always get the complete...

Hello Friends, I have a data dump which is enormous.here there is column which has multiple queue details as : DEV-.NET-L1 EIM-DSER-L3 BIP-PUBLISHING-L1 EIM-DQCORE-L1 BIP-ADMIN-L1 RA-CR-L1 BIP-DEPLOYMENT-L1 EPM-BPC-MS-L1....like wise there are more than 500 + unique queues Now I want...

@Debraj Roy Amazed to see this stuff. Absolutely brilliant Regards, Raja

Hello Narayan, Happy to see that you are heading towards the solution. You can go ahead with the scripting as the format would remain the same. And I'm hoping that the values which would reflect in the "Report" sheet would be in time format. Regards, Raja

@NARAYANK991: Much Thanks for your response. You got those points absolutely right. 1)There are few enteries which are spanning more than a row but this is how the tool is exporting the data and added to this we dont have have an option to customize the exporting procedure. This is something...

Hello Suresh, Many Thanks for sparing your time and working on my file.Just had a glance of your file and I must say you succeeded in resolving my query but only to some extent. The last swipe out value is mismatching for the employees. Nonetheless I really appreciate your effort Regards, Raja

Hello Friends, Need help in extracting the required numbers out from the data dump which is in a complex and disorganised format. Please refer to the attached file which has 2 sheets 1) Dump & 2) Report. The data in the dump sheet is basically the login and logout details of the employees...

@sgmpatnaik: Hello Bro, Thanks a ton for your time and effort. You are just awesome Regards, Raja Kamarthi

@Debraj Roy: Many many Thanks for your input. I spent a good amount of time looking out for a solution and now finally your resolution has brought a much needed relief to me. A big thanks to all the excel experts who have been helping me out unconditionally. Regards, Raja

@rmailk: The simplest way of pasting the comments from a cell to other is doing it through paste special option. First copy the range cells and then select the destination cell and next paste special. ALT+E+S+C And regarding the automated update of the comments, I'm not sure if this can...

@sgmpatnaik: In the spread sheet, when I click on the employee name, the same data gets reflected in cell C13 for eg if I click on cell E11 (Syed Nazim Quadri), this name gets reflected in cell C13 as well. Now I want the cell E11 to get highlighted with some conditional formatting. Thanks, Raja

@sgmpatnaik: I'm not sure if I got the right way of uploading a file, please click on the link to access the file: https://www.dropbox.com/s/p105tbpzwiwpsjl/Sample%20Sheet.xlsm?m Do let me know if you are unsuccessful in doing so. Thanks, Raja

@ sgmpatnaik: Much Thanks bro but when I tried running the script shared by you, I find only a part of code being applied i e "Range("C13").value = activecell.Value" is working absolutely fine but the active cell is not getting highlighted/formatted. Please look into this Thanks, Raja

@ Marc L: Thanks for your comment but unfortunately it was of not much help @ sgmpatnaik & shrivallabha: Manys Thanks for your inputs. May be I should I have put my query in a precise way for your better understanding. I tried hard to upload the file but all my efforts have gone in vain. I...

Its been quite a while now looking out for someone to resposnd to my query. Friends, please take out sometime and help me out as this is on high priority. I just need a VBA script which highlights the active cell and at the same time doesnt delete the active conditional formatts in the sheet...