View Single Post
 
Old 08-26-2014, 03:46 AM
rogcar75 rogcar75 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2014
Location: OU Country
Posts: 15
rogcar75 is on a distinguished road
Default

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
Reply With Quote