PC Review

Thread Tools Rate Thread

Re: VBA to create stock analytics display

Don Guillett
Posts: n/a
      19th Apr 2012
On Thursday, April 19, 2012 4:47:28 PM UTC-5, Mike Thomas wrote:
> Trying to figure out the VBA coding that creates a macro I can trigger atwill through a Button feature that does the following: Have a single column of stock symbols (beginning at A10) and would like to put the cursor on the first one, then have the current cell copied to another cell that is linked to a stock analytic program which produces various analytical values and displays them in range A1:H1. Would like the cursor which is currently on the active stock symbol in column A to move to the right two columns to column C and then print the analytical values from A1:H1 from column C outward. Once that is done, want the cursor to move back to column A, go down to the next stock symbol and wait for me to trigger the .
> This way I start with a column of stock symbols that I want to examine and when I hit the Button, the macro works its way down the column and I endup with a bunch of analytical data showing next to the applicable symbols.
> Am new to VBA with no experience and the more I read at various postings the more confusing it becomes.
> Thanks for your help.
> Mike

Send a file to dguillett1 @gmail.com with an explanation and before/after examples
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I add google analytics code to my web pages? =?Utf-8?B?a2VsbGllam9qbw==?= Microsoft Frontpage 2 31st Jul 2006 12:31 AM
new article on my site: Generating PowerPoint Reports from Google Analytics ChrisHarrington Microsoft Powerpoint 0 14th Jun 2006 09:20 PM
Google Analytics =?Utf-8?B?TWluZXIgTWFydHk=?= Microsoft Frontpage 3 18th Nov 2005 04:12 AM
Google Analytics Is Now Free FYIS.org/ Freeware 1 15th Nov 2005 12:28 AM
Access to Excel analytics Duncan Microsoft Access External Data 3 15th May 2004 08:22 PM




All times are GMT +1. The time now is 08:10 AM.