Posts by Potholes

    Good morning any and all


    My 80 year old brain has forgotten some basic stuff.


    What I have is 4 columns C,D,E,F starting on row2.

    In cell F2, i need a formulae

    If c2 is blank and D2 is Blank, and e2 is Blank, then show a blank cell in F2,

    If C2 is >" ",D2 is >" ",E2 is >" ", then in F2 (E2/D2) the answer as a in %


    I don't have a sample sheet to attach ATM


    Regards Peter

    Hi all readers


    A portion of a poem by Dorothea Mackellar


    'I love a Sunburnt Country, a land of sweeping plains, of ragged mountain ranges, of droughts and flooding rains'


    Some of us believe that we should now adopt


    'I love a Sunburnt Country, a land of sweeping plains, of ragged mountain ranges, of droughts and Bloody Flames".


    From my Wife and I we wish to extend the heartiest of season greetings, to ALL that have assisted me this year.


    Peter

    Good afternoon all


    Is it possible to run a 2 key Hot key


    example: Ctrl + A + M will open a given function within Excel


    Peter

    Code
    1. Function FirstNumber(RngToChk As Range) As Variant
    2. FirstNumber = RngToChk.SpecialCells([B][COLOR=#FF0000]xlConstants[/COLOR][/B], xlNumbers)(1).Value
    3. End Function
    4. Function LastNumber(RngToChk As Range) As Double
    5. With RngToChk.SpecialCells([B][COLOR=#FF0000]xlConstants[/COLOR][/B], xlNumbers)
    6. LastNumber = .Areas(.Areas.Count).Value
    7. End With
    8. End Function

    H Charles


    Thank you for you efforts so far,


    My observations:


    On the attached file I have put in the option of a 3 leg race, it would be rare depends on weather and track conditions.


    1/ We need the option that a rider may be Vetted out or Withdrawn before the race actually starts, so that in involves Column "C"
    2/ Lets assume that a rider has the first leg and is going out for the second leg THEY MUST HAVE a 1 hour REST you can see in The OPEN cells J11 and O11 the TEMP data there
    3/ When they enter BASE in H6 can the code scan for the last occupied cell for that rider then enter the BASE or TIMEout


    On a personal note please let me have your paypal account for some extra payments.


    Peter

    HI KJBox may I have your name please.


    OK Yes I can see your point there, F6 just displays the leg of the race in relation to the H6 entry It should not be part of your programming.


    I have entered 1 in D6, 1 in F6, 1 in H6, and 05:45 in J6, what do I need to do now, to get that across to the OPEN sheet in Row 14 Cell E14 please.

    Good Afternoon


    I have attached a sample file called "Enduro_2_Short.xlsm" this is a cut down file.


    On that file when you enter a number in D6, the enter a checkpoint number in H6, F6 will display the checkpoint number.


    That function is missing off the new file.


    What steps do I need to do to get Rider No 1 with Checkpoint 1 and time of 06:25 information over to the Open sheet cell E8 please

    Hi Peter Here


    I have paid the full $30 Dollars because $3 dollars seemed a silly amount to pay,
    I am not rich But I have to pay for each of my Bank transaction each month when I exceed a certain number.


    As I said If nobody took it on Then it was a donation to the forum.


    Peter


    Please ask away for any direction on my needs

    Look for data on " Front" sheet then lookup cells on "Open" Sheet and paste


    Front Sheet concerned cells are D6, F6, J6,
    Cells to be aware of L6 & Q6



    PayPal Transaction ID 9WL25823AP475942E $30. Full Payment


    Please Note


    I have read the rules but I figured $3 as a 10% I would be better off making the whole amount.
    Then even if nobody takes on the project I have made a donation towards the Forum.


    Peter

    Files

    • Enduro_3.xlsm

      (94.03 kB, downloaded 5 times, last: )
    • Book2.xlsx

      (18.17 kB, downloaded 5 times, last: )

    Good Afternoon all Maybe for Mr Pike to look at
    (Long time no speak OM)


    I have a program for use on Endurance Horse races, I am requesting some VBA to execute the data.


    On the " Sheet 3 " data is entered, then to be assigned to that rider on the " Sheet 1 ",


    The Book2.xlsx shows the before and after.


    Any thing that is not clear or problems please contact me



    There is 2 sample files



    Thank You in advance Peter

    Files

    • Book2.xlsx

      (18.17 kB, downloaded 68 times, last: )
    • Enduro_4.xlsm

      (93.62 kB, downloaded 69 times, last: )

    Carim


    As I cannot edit my post it makes it hard for make any adjustments along the lines of your suggestions.


    Any Idea How I can make it suitable for someone to assist me please.


    P