Ok thanks again
1 - I have installed the new Script, but i am not sure where the vlookup should be put at, and how, with the script, so that is one question?
2 - Is there a way in the script to change the #na that is showing up in the rows where players name don't have updates to their Player Value Column, maybe a $0.00 instead of the #na?
3 - Ok after all of this done, can the shape i created have to stay on sheet 1, or can I just add a shape whenever i run the script again?
4 - Also when the script is already ran and updated sheet 1, do i need to keep the datascrape sheet, and if i do, does it have to be in front of sheet 1 on the tabs below?
I know these questions are probably senseless, but i just want to clairfy what i can do and what i can't with the sheets, now with VBA scripts.
5 - And finally i just want to thank you for your time and what you do to help others out with these functions, your are truly Appreciated.
Thanks Rog
|