finish

  1. G

    Finding Data in a cell by looking for 3 variables

    Hello all. I have a little issue, that I would normally use VBA, but this time I would like to go formula driven. Data Locations: Date is in L:8 First Variable is in: L:7 = Finish Second Variable is in: J:8 = POP Third Variable is in: H:8 = ABC I wish to lookup the date in L:8, in an...
  2. N

    Need help

    In cell E19 I have a drop down list which has Pears, Apples and Bananas. In cell E20 I have the finish quantity and in cell E21 I have the start quantity. My questions are these: 1. Is it possible to use the same cells E20 and E21 for Pears, Apples and Bananas which have different quantities...
  3. R

    Formula to pull in start/finish dates?

    Hi all struggling with figuring out how to pull in start and finish dates from a cash flow. Say I have: Jan 19 Feb 19 Mar 19 Apri 19..etc $xxx. $xx For this example..the start would be Jan and finish would be Feb. How would I create a formula for this?
  4. V

    Nesting if then with and and or

    I have a sheet. There is a date column for length of task, start and finish of project tasks. The finish column is a formula of length of task plus start (so not in date format). To the right of these dates are quarters with quarter end dates. If the project is being worked on during this...
  5. J

    Adding Comments

    I'm writing a macro to add a custom comment. I have everything up to adding text to the comment working. How do I stop the macro from advancing while I'm adding text? Then once I'm done adding text, how do I detect a mouse click so I can turn the macro back on so I can finish and close the...
  6. S

    Let PowerQueries don't have time to finish with VBA

    Hi I have a VBA script that is supposed to remove the protection of the sheets, update two PowerQueries and then re-protect the sheets. When I run my macro, the queries do not finish, which causes me to get errors in the result. I would like script to pause until the first query is finished...
  7. J

    How To bring front userform

    hi all, i have a userform when user click on Start PRocess, open 2 excel files and extract data.... working............................. when finish, open second file. i want show on the front, the USerform i try: AppActivate FArchForm.Caption but not worked.... How to? Thanks
  8. S

    Counting how often a time appears

    Hi, I am hoping someone out there will be able to point me in the right direction as I have been searching for ages and can not seem to get anything to work that is not really long winded. A B C D E <tbody>...
  9. N

    TimeSpans -Splitting Hours

    New Member - first time post - Hello all, Does anybody know how to calculate the following- (A1)Start 25/11/2018 17:00 (B1) Finish 26/11/2018 10:00 - Total Elapesed Time = B1-A1 = 17 HRS The elapsed time between the start and finish is 17 hrs - however is is split over two days What...
  10. J

    Date and time

    Hello, Hopefully soon can help me. I am trying to work out how to create a formula to make a plan showing when a total process will be finished and also each stage start and finish times. The time for each stage is fixed, but the initial start time may vary and the process in total will span 3...
  11. P

    Time

    Good morning all I use a spreadsheet to do my shift updates at work but I am finding the other shifts are entering false hours to make things look good. So what I would like to do is pull the hours from the start time and finish times the issue I am having is some production runs finish a...
  12. D

    VLOOKUP across sheets

    Hi All, This project is way above my abilities, so I'm asking for help. Sheet 1 must contain the following data, in the following manner: The employee's name in Column B, their Department in Column C, the day of the week in column D, their start time in Column E (on 24 hour clock), and...
  13. K0st4din

    Macros, first free cell to be with black text

    Hello, everyone, please for your help, for a macro that i do not know how to do. I have 15 worksheets with specific names (peaches, tomatoes, apples, etc.). In each of them all cells are made - the text in them is red. But in each worksheet, the length of the rows is different: for example: in...
  14. J

    copy/paste

    Why wouldn't this code work in a macro activated by a command button! It copies the cell to the clipboard but won't finish with the paste! Stumped!!:confused: P.S. Button is on active cell sheet. Worksheets("Sheet1").Range("N2").CopyActiveCell.PasteSpecial Paste:=xlPasteFormats...
  15. P

    Drivers milage / time sheet

    Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...
  16. P

    Help with a drivers milage / time sheet

    Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...
  17. K

    Calculate # of days from start & finish dates etc.

    Hi all. I'm needing to calculate the number of days employed for the financial year if there is either a start and/or a finish date. But if both are blank, as it is for the employee in Row 7, then I need it to return the value of 365. Hoping you can help. See below screenshot. Thanks in advance...
  18. E

    Formatting Start and Finish Dates Based on Grouping Levels

    I have an Excel workbook that I copied from Project and formatted based on the Project file. I have inserted a picture below of my Excel workbook. I grouped the rows by their outline level in order for the grouping to match the summary and sub-tasks format in Project. I was wondering if their...
  19. C

    VLOOKUP which gives highest value

    Hi, The spreadsheet I am using has 3 orders which make one bulk order. The 3 orders have 3 different finish dates. Is there a way of putting on a vlookup formula which then chooses the highest date (this is to create a pivot table). For example: Order Finish date Bulk order 1...
  20. A

    Allocate personel to different jobs not all to the same one

    Really need assistance . I have a workbook that calculates start and finish dates of task based on hours available to work. The problem that I have is that it assigns all hours to the first job instead of to different task. If I have 5 workers I want 5 jobs going simultaneously once one worker...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top