+ Reply to Thread
Page 4 of 7 FirstFirst ... 2 3 4 5 6 ... LastLast
Results 46 to 60 of 97

Keeping Track of high game bowling scores

  1. #46
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hi my Friend,

    I put a bolder around first 50 names in list and create a dup and remove the dup I lose all the formatting.
    Where and how do you create the "Dup"
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  2. #47
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Revised sample Workbook attached.

    Do what you like, use the "Clear" Button, Create a Copy(Sample on Sheet2), make your changes and Paste it as it appears(Without Formats), back to Sheet1, and see what happens.

    Regards.

  3. #48
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    Thanks Winon
    I added code to the Do It macro to format the bolder back, Wow I get to see how you did it.Learning something new daily.Thanks for trying something new for me,you
    have been so much help.
    Z

  4. #49
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hi Z,

    Thank you for the feedback.

    I added code to the Do It macro to format the bolder back,....
    That is totally unnecessary, since the Delete Dups Code in the Do It Macro can NEVER remove Formats. It places an extra burden on that Macro, and I would suggest you remove it, and see for yourself.

    Regards.

  5. #50
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    Ok I will remove,when I ran the Do it Macro that is when I lost formatting.

  6. #51
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Does it do the same on my latest uploaded Workbook?

  7. #52
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    No, last one works Great. Thanks

  8. #53
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    I am glad to hear your problem seem to be Solved with the last Workbook. It is really a pleasure working with someone like yourself who knows what he wants, and is so keen to learn!

    Thank you for your patience and for the "Rep", it is much appreciated.

    Kind regards.

    W

  9. #54
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hi zplugger,

    Maybe you would like this revised attached Workbook better?

    Kind Regards.
    Last edited by Winon; 09-16-2016 at 11:19 PM.

  10. #55
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    Here is a challenge Winon, If a name shows up twice in the top row the cell turns yellow. So if Efren*Oglesby has high game on lane 1 and has high game on lane 6 both cells would be yellow.But if Efren*Oglesby had the second highest game on lane 6 nothing would happen. I Think for this to work we would have to use the names in BI to BW.

  11. #56
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Do you call it a challenge? Please

    However, you are correct with your comment;

    I Think for this to work we would have to use the names in BI to BW.
    I "Hate" you for taking me to task. but love it!

    It needed to change a few things, but as you will see in the revised attached Workbook, I hope it satisfies your latest requirement.

    Best Regards.

  12. #57
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    Like the way you think,I never of tried that way. You amaze me on you knowledge,you solution should work perfect.
    z

  13. #58
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Thank you for the kind words zplugger,

    It is people like you, and others on this great Forum, making it worth my while to still hang around, 'till Higher Powers call on me for whatever awaits.

    Greetings!

  14. #59
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,136

    Re: Keeping Track of high game bowling scores

    When they have your label Forum Gura,they weren't kidding. Seems like any question I have you will answer,(Thank You). Ok you found a way to show if a person is tied for first place,is there a way to put that name in the yellow cell.I know this won't be easy,better sleep on it for another day my friend.

  15. #60
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,888

    Re: Keeping Track of high game bowling scores

    Thank you my Friend, it is long past my sleeping time, but don't worry, I shall do that for you, A.S.A.P,

    Good Night, it is already almost 2 am Sunday her by us.

    Hope you understand.

+ Reply to Thread
Page 4 of 7 FirstFirst ... 2 3 4 5 6 ... LastLast

Thread Information

Users Browsing this Thread

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

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