kansfan2001
New Member
- Joined
- Aug 22, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Ok this might be a bit rough LOL..... So Sorry first off!!!!!
I am trying to write a vba that will take information from Sheet 1 (which is pulling the listed information from a picks page and displaying it here in fighters name format ILO of X) and dictate who won the fight based on the information provided
(pic below is sheet 1 name eric sits in cell B20)
I want the VBA to take that information from Sheet 1 and dump it all on sheet 2 with the winner specified. It would look like this with the green highlight as winner and strike thru red as loser of the fight. Then it would need to total based on fights won.
I have only been able to make it partly work by using conditional formatting but its just not working correctly. I just don't have the ability to make the connection on my own.... So hopefully someone with way more skillset in excel vba can help me out
Thanks a bunch,
Tim Gates
I am trying to write a vba that will take information from Sheet 1 (which is pulling the listed information from a picks page and displaying it here in fighters name format ILO of X) and dictate who won the fight based on the information provided
(pic below is sheet 1 name eric sits in cell B20)
I want the VBA to take that information from Sheet 1 and dump it all on sheet 2 with the winner specified. It would look like this with the green highlight as winner and strike thru red as loser of the fight. Then it would need to total based on fights won.
I have only been able to make it partly work by using conditional formatting but its just not working correctly. I just don't have the ability to make the connection on my own.... So hopefully someone with way more skillset in excel vba can help me out
Thanks a bunch,
Tim Gates