+ Reply to Thread
Results 1 to 15 of 15

Revisit some coding to reflect the new additional data to correct the output display

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Revisit some coding to reflect the new additional data to correct the output display

    Hi all and thank you for looking at this thread Hopefully another for SINTEK

    Owing to the committee moving the Goal posts on me I need to do some revision on the code as listed
    below, the original code only needed to see if it was a case of 2 legs.
    Now they have asked for if for arguments sake there are 3 legs and for testing purposes only there will
    be a total of 10 checkpoints,the number of Kms per leg can vary day-to-day as do the number of CPs in each leg.
    The DEMO page has a lot NO A BLOODY LOT of formula’s.


    Before we can enter a figure into " Front Sheet " cell " H6 " we need to check cells " U4 to W4 ",
    to see how many Legs the race is run over, The figures below the 1 2 3 are the lengths for each leg.


    Then check Cells " U9 to W9" to see there if a number in those cells, these cells show how many
    checkpoints are in each leg, and will govern what LEG can be displayed in " Cell F6 ".


    For arguments sake if there is a figure in " Cell U9 " and it is a " 3 " then only " 3 " checkpoints
    will be in that the leg of the race, so in the current situation if " 1 2 or 3 " is entered into H6 " F6 "
    will show " 1st Leg " likewise when " 4 5 6 or 7 " will show " F6 " 2nd leg, and " 3rd leg" . etc etc.

    Please Login or Register  to view this content.

    Many Thanks in Advance

    Pete
    Attached Files Attached Files
    Last edited by Potholes; 08-02-2019 at 04:10 AM.
    One I have learnt over the last few months, " You are NEVER too old to learn ".
    Sometimes I forget to say " Thank You " for your assistance, so here I say " A BIG Thank You. "

  2. #2
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    G'day to all and Sintek

    I have my thread here that part of the coding was done by Sintek a little while back,
    I am hoping he can take the time to revisit his code for me please.

    Peter

  3. #3
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Look up cells and return a response to solve anther thread.

    Hi all

    I have an outstanding thread at the moment so if I can get an answer to this thread it may
    solve my other thread which I will nut out myself.


    How do I rewrite the VBA code below to interpret that if a group of cells located in

    if " U16:U19" = "Case 1 : Target.Offset(, -2) = "1st leg""

    if " v16:v19" = "Case 2 : Target.Offset(, -2) = "2nd leg""

    if " w16:w19" = "Case 3 : Target.Offset(, -2) = "3rd leg""

    Please Login or Register  to view this content.
    I trust I have attracted someone interest.

    Many thanks in advance

    Peter

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Pete - this was effectively a duplicate, so I've merged the two threads.

    It's extremely unclear what you are trying to do here. What relevance do these cell ranges have? Are you trying to create lookups?

    You need to think about improving the thread title to get people to look at this. It is all very vague.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Hi Ali
    I was thinking this may be the case Thank you, I should have sought direction first.

    Pete

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Are you going to update the thread title? Are you going to give clarification by answering the questions I asked in post #4?

    Without clarification, I doubt you'll get any help with this. At the moment, it's one of your bowls of spaghetti. We need simplification.

    For instance:

    Range U16:U19 contains x, y, z.
    Range V16:V19 contains a, b. c.
    Range W16:W19 contains 1, 2, 3.

    If the target cell shows 1 I want X to happen.
    If the target cell shows 2 I want Y to happen.

    etc.

    Imagine it's a recipe.

  7. #7
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Stand by one BRB

    P
    Last edited by AliGW; 08-03-2019 at 02:45 AM. Reason: Please don't quote unnecessarily!

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Hi Peter...
    Also in your description and upload in post 1...
    "U16:U19"
    "v16:v19"
    "w16:w19"
    There is nothing in these cells...Also as per AliGW suggestion...Please explain in detail a step by step process of all possible scenarios and expected outcome...
    Don't have much time today, but if not solved by Monday, will look into it...Should be pretty simple if your explanation is detailed...
    Last edited by sintek; 08-03-2019 at 03:07 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  9. #9
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    HI all

    Please give me about 1 hour to sort out some problems here before I upload the file, and better wording/

    P
    Last edited by AliGW; 08-03-2019 at 03:09 AM. Reason: Please don't quote unnecessarily!

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Administrative Note:

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

  11. #11
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Hi all and thank you for looking at this thread Hopefully another for SINTEK

    This is an update to my entry in Post 1 of this thread. My requirements haven't changed just the NEW Tables.

    Since I started this section of the Endurance Horse Clubs project, we ( I mean Ali ) has set up a table
    as shown on the " Memory Sheet ", due to Ali Tables being available below may be a bit easier to work things out.

    On the " Memory Sheet " in Cells " J2 to J4" will show how many checkpoints are in each of the leg, in cells
    " K2 to K4 " shows which numbered checkpoints are in those legs.

    On " Memory Sheet " for arguments sake if there is a figure in " Cell J2 " and it is a " 2 " then only " 2 " checkpoints
    will be in that the leg of the race, so in the current situation if " 1 or 2 " is entered into H6 " F6 "
    will show " 1st Leg " likewise when " 3 4 5 or 6 " will show " F6 " 2nd leg, and " 2nd leg" . etc etc.


    Please Login or Register  to view this content.
    I will upload the current file.

    Thanks to any and all

    Peter
    Attached Files Attached Files
    Last edited by Potholes; 08-07-2019 at 01:10 AM.

  12. #12
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Not explaining in detail....I am going to assume that Sheets("Memory").Range("K2:K4") is the deciding factor...
    Please Login or Register  to view this content.
    Last edited by sintek; 08-07-2019 at 07:35 AM.

  13. #13
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Hello All

    Att Sintek

    A BIG BIG Thanks you it works a treat however I had to comment out a couple of lines
    as they were causing an error.


    'Option Explicit

    'Private Sub Worksheet_Change(ByVal Target As Range)


    And again

    Many Many Thanks

    The system will Not allow me to give any more Reps on this topic to you.

    Peter

  14. #14
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Glad I could help...
    Just in case you enter a Checkpoint that does not exist then add red snippet...

    Please Login or Register  to view this content.

  15. #15
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Re: Revisit some coding to reflect the new additional data to correct the output display

    Thank you Mr Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Additional Help With AutoFilter VBA Coding
    By kstoneman in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-09-2017, 09:36 AM
  2. VBA compare and output data to another sheet doesn't copy in the correct range
    By maym in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2017, 05:57 AM
  3. [SOLVED] Excel Formula to reflect correct number sequence based on certain conditions
    By arnel_10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2017, 08:33 AM
  4. Data tables not returning correct output
    By blaketus17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2016, 10:56 AM
  5. Replies: 1
    Last Post: 03-17-2014, 04:18 AM
  6. Locating Minimum value, output additional data
    By bucklj2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2009, 01:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1