+ Reply to Thread
Results 1 to 4 of 4

How to Automate a SpreadSheet?

  1. #1
    Registered User
    Join Date
    12-13-2009
    Location
    new york, usa
    MS-Off Ver
    Excel 2003
    Posts
    17

    Question How to Automate a SpreadSheet?

    I have a spread sheet (sheet2) that runs an add-in and does some calculations and arrives at a result which is a number in cell P6. All I have to do is type in a Stock Symbol in cell A1, and the sheet runs the add-in, calculation automatically. If I change the symbol in A1, the sheet re-runs the add-in/calculation and gives me the result for the new stock in cell P6.

    Sheet 1, has a list of stocks, indexed in Column A.

    Rather than me changing the symbol manually in sheet 2 cell A1, how can I automate it such that it will run the functionality automatically for each symbol in Sheet1 column A sequentially and then tabulate the results for each stock/symbol in Sheet 1 column B.

    I tried to attach the sheet/book herewith, but could not. It is less than 100KB in size.

    Any help would be appreciated.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to Automate a SpreadSheet?

    Your post does not comply with Rule 8 of our Forum RULES.
    Cross-posting is when you post the same question in other forums on the web.
    You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
    We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
    Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Why bother linking to x-posts: http://www.excelguru.ca/node/7

  3. #3
    Registered User
    Join Date
    12-13-2009
    Location
    new york, usa
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: How to Automate a SpreadSheet?

    Ok, I will keep that in mind.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to Automate a SpreadSheet?

    As requested - please add the appropriate link(s) - or if preferred let me know and I will close this thread for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1