• 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

    How to create a income statement with multiple month and comparison to actual Vs Budget number?

    Hello All, Does any one have any excel workbook or have any ideas on how to create a excel dashboard for Income Statement, where I can show month on month actual values vs budgeted value for each month and variance by line items. I can paste the Raw data for budget and actual for every month...
  2. A

    How to track employee time in excel using Macro

    Hi Vletm, Thank you for your time and efforts, :) this file looks very good now and just with few modification I can use it. Sorry for any trouble if I may have caused. Thank you Akash
  3. A

    How to track employee time in excel using Macro

    Hi Vletm, Its giving error, see attached.
  4. A

    How to track employee time in excel using Macro

    Hi Vletm, Amazing, Thank you for making this it looks really Nice. Just few more thing, I wanted to use data validation on for Tasks Row, so the user can choose accordingly on the task he or she is working, as there could be multiple tea break or Multiple task he or she might be working on so...
  5. A

    How to track employee time in excel using Macro

    Hi vletm, 1) You should know what do You want to measure? - (I am looking to prepare file which track time on daily basis of every employee on different activities, so that will help us to know how much each employee utilized and who has availability) 2) .. as well as what someone wants for...
  6. A

    How to track employee time in excel using Macro

    Thank you so much for your Help Vletm, and Sorry for delayed response, Do you have any suggestion How can I improve this format ? if you have seen any format in past ? Thank you Akash
  7. A

    How to track employee time in excel using Macro

    Hi, How can we track daily time of employee in excel. (Task1, Task2, Breaks, Meeting, Away from system - if system is idle for like 10 min. I have attached a excel file and points which mentioned I can explain, this file I got through some website. 1) Login and Logout time - Excel should...
  8. A

    How can I skip few column from a range ?

    Thanks Luke, This Sounds Good, Thanks for all the help. Akash
  9. A

    How can I skip few column from a range ?

    Hi Asheesh, My requirement is almost same what Luke formula is giving. :) Thank you Akash
  10. A

    How can I skip few column from a range ?

    Hi Luke, Thank you so much, This formula works very good, Is there a better way you think we can use to this task using Macro ? My only requirement is to pull Actual hours and Resource details in cell range (R16:T18). Thannk you Akash
  11. A

    How can I skip few column from a range ?

    Hi Asheesh, Is it possible ? If you can let me know how we can skip column in above copy code which i have created I can work on rest. Thank you Akash
  12. A

    How can I skip few column from a range ?

    Hi Asheesh, In the attached file from Sheet1 I want to copy only actual hours for range mentioned in sheet2 cell B6 and AJ18 (*in sheet2 incorrectly mentioned as T18) like that for all the other divisions (2000 & 9000) and paste it in sheet2 from under column H9 Thanks Akash
  13. A

    How can I skip few column from a range ?

    from range B1:K50 sometime may be I want to skip 3 column or 4 column , So suppose if in sheet 2 cell C1 has value "2" then starting from range B1:K50 in sheet1 it should skip 2 column if its given 3 it should skip 3 columns and so on. How can we do this ? Sub testing()...
  14. A

    How to copy data if Range of that data given a cells using Macro

    That's It :) Thank you so much
  15. A

    How to copy data if Range of that data given a cells using Macro

    Hi Yasserkhalil, Sorry for delayed response, Please see in the attached file 1 sheet is the data and 2nd sheet is what output I am looking for. Picking columns D, G, J and M, . From the range defined in cell A1 and B1. Thank you Akash
  16. A

    How to copy data if Range of that data given a cells using Macro

    I think I did not explained it properly value given in cell A1 and B1 (D1 and H20) is range like (D1:H20) so it will copy complete data. Now what I am looking is starting from cell D1:20 it should copy then skip next column E completely and copy the F1 to F20 and so on till H20 Thank you
  17. A

    How to copy data if Range of that data given a cells using Macro

    Hi Yasserkhalil, Thank you for your response, Is it possible in above code to copy Individual column and not the complete data? Like if in Cell A1 data start range is given as D1 and in cell B1 end date is H20. Is it possible to skip data in column E, G and copy data from all other column D,F...
  18. A

    How to copy data if Range of that data given a cells using Macro

    How can we copy data from a range if Data's start cell and End cell is mentioned in 2 different cell. which is not part of that data. Example: Within cell A1 start range of data is given as D1 and in cell B1 End range of data is given as H20 and copy this data and paste in sheet2 so values in...
  19. A

    How can we copy data while skipping few column each time?

    I thought the old post became more confusing and this time I only want to know how we can skip from one column to another which we need to add i think on this line of code. For Each mycell2 In myrange2 Sheets("actual vs Plan").Activate 'If mycell2.Value =...
  20. A

    How can we copy data while skipping few column each time?

    Hello This time on just how to copy by skipping same number of column each time. Friend I have a small code below which copy Actual hours highlighted in (Blue) from actual vs plan tab to Burn macro tab and paste on respective dates in burn tab ('date for which hour belongs to which should be...
  21. A

    Extract data by skipping same number of column.

    Hi Deepak, Here is what I am trying to achieve, 1. Actual Vs Plan sheet is master tab and Burn Macro is just a copy of that with few required information. 2. In Actual Tab under column Q:Q I have Division as 01-1000, 01-2000. 3. From column R to U is employees details. 4. From column X to AH...
  22. A

    Extract data by skipping same number of column.

    Does anyone has any suggestions ?
  23. A

    Extract data by skipping same number of column.

    Hello, I am just stuck with this problem Please help. I want to Extract Hours data from this attached file on 2nd (BurnMacro) tab from the 1st tab (Actual vs Plan) tab. I may require to extract sometime Actual hour, Budgeted Hour or Plan Hour based on requirement, so if we can pull Hours using...
  24. A

    How to loop based on value given in 2 cells on different sheet

    How can i define below start range as given in attached excel sheet2 to do a Loop ?? Please help Dim startrng As String Dim endrng As String startrng = Sheets("BurnMacro").Range("B5").Value endrng = Sheets("BurnMacro").Range("C5").Value For counter = 16 To 20 If Sheets("Actual vs...
  25. A

    How to loop based on value given in 2 cells on different sheet

    attached is Macro enabled excel file
Back
Top