• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Calculation of Service days

    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...
  2. A

    Macro to record Start and End time

    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)...
  3. A

    Macro for Searching the data from sheet 2 and input in sheet1

    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...
  4. A

    Remove % symbol from numbers

    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...
  5. A

    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...
  6. A

    Joining several Macro files in to one single macro sheet

    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...
  7. A

    Creating copy of cell automatically

    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...
  8. A

    Addition of previous week figure with current week and so on

    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...
  9. A

    count data of multiple cells based on criteria

    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...
  10. A

    Hiding colored rows in excel of office xp version

    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...
  11. A

    Calculate no.of days present week-wise

    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...
  12. A

    Urgent..Need Help for date calculation

    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...
  13. A

    Date calculation(Urgent)

    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...
  14. A

    formula to calculate dates in excel

    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...
  15. A

    Auto populate items in excel after selecting particular item.

    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...
  16. A

    conditional formatting for dates

    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...
Back
Top