+ Reply to Thread
Results 1 to 4 of 4

Copy price based on stock symbol

  1. 05-07-2017, 11:19 PM #1
    jp001
    jp001 is offline
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Copy price based on stock symbol

    Sadly my VBA is rather rusty and I'm too time-poor to figure this out just now:

    I have two columns in sheet 'Temp' like so:

    ABMD 133.03
    ADI 75.79
    AEIS 74.55
    AL 36.61
    ALGN 138.03
    etc...

    where Col A is Stock Symbol and B is Price.

    I need a snippet of VBA code that searches for the same stock symbols
    in sheet 'Main' in Col B there (can occur multiple times) and insert the relevant
    Price in Col M.

    Hoping that was explained clearly enough, thanks for any help
    Reply With QuoteRegister To Reply
  2. 05-07-2017, 11:25 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy price based on stock symbol

    why does it need to be VBA, sounds like a vlookup formula would suffice?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 05-08-2017, 06:58 AM #3
    jp001
    jp001 is offline
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: Copy price based on stock symbol

    Quote Originally Posted by humdingaling View Post
    why does it need to be VBA, sounds like a vlookup formula would suffice?
    You're right! Told you I was rusty
    Reply With QuoteRegister To Reply
  4. 05-08-2017, 08:30 PM #4
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy price based on stock symbol

    one of my easier questions answered today
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0
    By meerabell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2015, 07:42 AM
  2. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  3. [SOLVED] Copy price to more than one product - Stock List
    By Ben1985 in forum Excel General
    Replies: 2
    Last Post: 08-11-2014, 12:42 PM
  4. Bootstrapping of stock price (Data based simulation)
    By Ajohs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 11:25 AM
  5. unit price - Cost price with condition (date, price, and stock)
    By ferrylukito in forum Excel General
    Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  6. How to get current stock price and previous close of a stock from National Stock Exchange
    By Solomon_raj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  7. [SOLVED] how to copy old price data onto new stock list if match exists?
    By julan in forum Excel General
    Replies: 2
    Last Post: 06-28-2005, 12:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1