Hello,
Hello,
-I have been looking deep into the bowels of the Internet searching for help with my excel project. I have been working on this for the majority of the day and have been determined to make this work.
-I want to make a simple spreadsheet to update stock quotes. Basically three columns symbol, name, and current price. I have about 600 stocks that I want to watch. After several frustrating hours, I have been able to make 3 worksheets that will update using the already install WebQuery. I don’t like the format. I simply want to take the little information that I want and put it into a clean format on another page. How do I copy this information from the three worksheets (had to make three because it would only accept 200 quotes at a time) and put it on one clean worksheet? I am new to using excel and anything but its most basic capacity so any info will help.
-Also, is there a better way to use WebQuery to just pick out the info I want? Am I going about this the right way?
I really appreciate the help…….I am close to slamming my head into the monitor…
THANKS….
Hello,
-I have been looking deep into the bowels of the Internet searching for help with my excel project. I have been working on this for the majority of the day and have been determined to make this work.
-I want to make a simple spreadsheet to update stock quotes. Basically three columns symbol, name, and current price. I have about 600 stocks that I want to watch. After several frustrating hours, I have been able to make 3 worksheets that will update using the already install WebQuery. I don’t like the format. I simply want to take the little information that I want and put it into a clean format on another page. How do I copy this information from the three worksheets (had to make three because it would only accept 200 quotes at a time) and put it on one clean worksheet? I am new to using excel and anything but its most basic capacity so any info will help.
-Also, is there a better way to use WebQuery to just pick out the info I want? Am I going about this the right way?
I really appreciate the help…….I am close to slamming my head into the monitor…
THANKS….