Recent content by ashish navale

Hi, I am working on a project of time & attendance. In a sheet row B1 has Hire date, Row B2 has Year End Date i.e., 31.12.2012. My requirement is when I input any date in B1 I should get output i.e, no. of working days in a year in Row B3 excluding weekends. Please help me with a perfect...

Hi Luke, Thank you so much.. The Macro worked wonderful. I appreciate your knowledge of excel and macros specially. Only because of you I was able to complete my task successfully...Thanks once again :)

Hi Luke...m in urgent need of ur help...could you plz help with a solution for my above query...

Luke...in the above post I forgot to mention one thing..the trackers are going to be the shared workbooks...so as per my convinience I wish to have the above said feature added in last macro code given by you..I know you can do it.. :)

Hi Luke..the macro given by you worked fantastic. Everybody in my team were impressed with your knowledge of macros. Now I am given responsibility to develop trackers for two more projects. But now this time I am expected to make a slight change. When I enter data in column B the system time...

HI Luke, The above macro worked fantastic. Now I am facing a small problem which I forgot to share with you in advance. When I share the workbook I get error "Method 'Protect' of object'_Worksheet' failed". Maybe because when workbook is shared it does not allow to protect cells. Is there any...

Hi Luke...this macro is working wonderful..could you please help me with one more solution. I want the start and end time to be locked automatically after entry is over so as to avoid any changes..so can it be adjusted in above macro itself.

Hi, I am developing a production tracker. In this tracker the start and end time should be generated automatically. I will explain my requirement in detail. Format of my tracker is as below: Column A (Date), Column B (Request Id), Column D,E & F are part of Process, Column G(Start Time)...

Actually I don't want data which is unique. When I say I want to find any name, I want a result which will throw data having all the similar names, as some times the emp ids are absent and only data I have is name. Is there any solution for this??

Hi, I have a file in which there are details of employees like first name, last name, emp id, dob etc. These details are available in sheet2. There are nearly 50-60,000 employees. My requirement is that I need a macro which will search data from sheet2 and give me output in sheet1. Eg.If I...

Hi, I have a report in which there is percent column. The numbers provided in the column are with '%'symbol. I am unable to understand as how to remove this symbol. Because if I try to remove symbol numbers change when symbol is removed..I want the number remain as it is and only symbol should...

Hi..Need help for automatic updation of dates

Hello, I have a report in which I get data for weekly production. In this sheet there is heading for weeks of month. eg. In 1st column lets say on A4 cell it looks like "1st Week (2 Jan - 6 Jan)" Then on B4 "2nd Week (9 Jan - 13 Jan)" and so on..So my requirement is as below: 1. I want a...

Hi I have 2 macros which I want to combine in one separate Macro sheet. The file name of 1st macro is "Merge data" and other name of macro file is "Join data". The scenario is as below: 1. I generate 4 excel reports from SAP.(Rewards UK, Rewards US1,Rewards US2,Rewards US3) 2. From the 1st...

Hi Vijay, Could you please guide me as how to prepare this macro. Because when I did using following steps it did not worked.. Open Excel--Alt+F11--Insert-Module Then I copied the last code which you said. I saved the file first in normal way. I didn't worked. Then I saved as Macro enabled...