+ Reply to Thread
Results 1 to 4 of 4

Stock movement columns monthly pulling

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Stock movement columns monthly pulling

    Have attached the file

    Want formula to go check data on sheet2 and plug stocks in respective columns of sheet1

    Thus I need the formula on b2 that I will drag rightwards and downwards

    Expected result 7 for the item 239.000.07 to go into JULY , 3 for item 239.000.08 for JULY and 1 for item 239.000.08 in august and -1.37 for item 239.000.09 in the month of july
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Stock movement columns monthly pulling

    Hi makinmomb, is this what you're looking for?
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Stock movement columns monthly pulling

    Yes ALVIN this is it , I even use two of your exact answered as work files, the tile program that fetches data accordinging to Tile Size and Tile Surface and that one called repeat and new clients count

  4. #4
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Stock movement columns monthly pulling

    You're welcome, thanks for your feedback and reputation


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Estimate the monthly return of your chosen stock and the S&P 500
    By kfaloyin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 07:32 PM
  2. Pulling in Stock Quotes via Web Query
    By SilverDollar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-27-2008, 11:44 AM
  3. [SOLVED] pulling stock quotes into a spreadsheet
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 07-03-2006, 09:25 AM
  4. Monthly Stock Return Volatility
    By frank in forum Excel General
    Replies: 6
    Last Post: 02-21-2006, 01:25 PM
  5. [SOLVED] URL string, pulling in Stock Data
    By William Benson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2005, 01:05 AM

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