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,
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)...
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...
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,
I need a technique through which excel will automatically create the copy of data I entered in particular cell.
Eg. If I enter 50 in cell A1, excel should create the copy and automatically enter 50 in B1 cell. Again when I edit cell A1 and enter another number it should copy that number...
Hi,
I have a report which I run every Tuesday. In report the Column H is 'Total' column. Column G is 'Request Processed' column.
Now when I enter the count of request processed in column G, the previous weeks total(Column H) must get added with the current numbers which I entered in Column G...
Hi..
I have a Tracker where I have to update the daily request processed under US or UK. In column A there is date(dd-mmm-yy), In column B there is request id(eg.1-12345678), In column C there is country data..i.e., UK or US. In the same workbook I have made a different sheet named Service...
Hi..
I have a report in which there are about 200-250 records. Out of these records there are some exceptional cases which are highlighted in yellow. I have to manually hide the rows which are yellow colored. As my company is using excel of office XP version I find it difficult to hide the...
Hi,
I have a production tracker which is used to maintain work done daily by employees in the project. There are multiple entries for same date in this excel. The thing is that my Manager wants week-wise attendance of employees in same excel but different sheet. There are four boxes named as...
Hi,
I have a report in which there are no. of dates given. In that report I have to find out any date which is greater than one month in past....and any date which is greater than six months in future..month should be given more importance rather than days. Because for e.g if today is...
Hi..
Plz help with a formula for conditional formatting..
I have an excel sheet in which there is a column of dates(MM/DD/YYYY)..
The formula should be able to highlight any date which is greater than one month in past. The formula[=today()-31] previously u gave did not work to my...
Hi...I want a formula which will calculate dates which will be greater than one month in past...irrespective of any date..and also calculate date which is greater than six months in future irrespective of any date..
could you plz help me with a formula which will work...as I want this formula...
Hi...I have query in my excel sheet...Its a transport delay tracker which I update as and when I receive email. I have to enter date, emp id, emp name, emp manager name, manager's manager name and place of residence of emp. I want a formula where I will select only the name of emp using drop...
Hi,
I have a report in which there is a column of dates in mm/dd/yyyy format. Here I have to find out any dates that are greater than one month in past with respect to current month. So I need to do a conditional formatting which will highlight the above criteria in red font. Whatever the...