finish

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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