+ Reply to Thread
Results 1 to 32 of 32

formula for show monthly purchase stock, sale stock & balance stock

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    formula for show monthly purchase stock, sale stock & balance stock

    R/Sir
    i am add new sheet name Monthly Report in this excel file than in monthly report sheet than i am choose September month than show Total Purchase
    Stock, show total sale stock & show balance stock of September month total purchase stock data pickup from the the purchase sheet & total sale stock was pickup form the sheet2(1-9-2015), sheet3(1-10-2015),sheet4(2-10-2015), sheet6(3-10-2015) & than added new sheet(4-10-2015) sale stock this was included to monthly report total sale stock please send the formula for monthly report sheet Total purchase stock coulumn, total sale stock & balance stock columns, thanking you sir i am send the attachments sir please see the attachments sir
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Please reply sir

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Excel 2019
    Posts
    447

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Hi
    please find the attached
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,124

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Other way


    Kind regards
    Leo
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    than i am click on the create report the total purchase stock was not display & than i am choose September the total Purchase stock was pickup from purchase sheet than i am choose October Month the total Purchase stock was pickup from purchase sheet All October months dates the total sale stock was display wrong than i am choose September month the total sale stock was pickup from sheet2(1-9-2015), than i am choose October month the total sale stock was pickup from sheet3(1-10-2015),sheet4(2-10-2015), sheet6(3-10-2015) than i add new sheet this new sheet Total sale stock was automatically plus in total sale stock thanking you sir

  6. #6
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Respected Sadath31 Sir
    please Reply Sir & resolve this issue sir thanking you sir

  7. #7
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    please Reply Sir

  8. #8
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    please Reply Sir

  9. #9
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    try this
    "Add Reputation" if it works... mark solved if done...

    Hii see attached file "Total Sale Stock" corrected....
    Attached Files Attached Files
    Last edited by mangesh.mehendale; 10-15-2015 at 04:11 AM.
    Don`t care, take care...

    Regards,
    Mangesh

  10. #10
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    please correct total Purchase Stock & balance Stock than i am choose September month show total purchase stock & balance Stock of September month, than i am choose October month show October Month total Purchase Stock & balance stock please correct this, "Total Sale Stock" Columns working fine sir thanking you sir
    Last edited by rana19; 10-15-2015 at 05:25 AM.

  11. #11
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    okay wait.... You have mentioned only regarding sales so I didn`t check purchases...

  12. #12
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Okay done now mark this thread as solved..... "Add reputation" to answer...

    see attached file...
    Attached Files Attached Files
    Last edited by mangesh.mehendale; 10-15-2015 at 05:46 AM.

  13. #13
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    r/sir
    please correction in balance stock

  14. #14
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Where is opening stock??

  15. #15
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/Sir
    Purchase Stock is a opening Stock Sir

  16. #16
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    then simply apply the formula Col. C less Col. D which will your closing balance.... But What if there is some stock from say in Sept. 15 you purchase FCM Qty- 100 sold in Sept. 15- Qty 95 then Qty-5 (100-95) is balance with you... So, now 5 will be your Ope. Stock for Oct. 15..

    Again you purchase in Oct. 15 .... 100 Sold- 98 now your closing balance for FCM will be Qty. Sept.- 5 +Oct.-2 = Qty 7

  17. #17
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    i am not understand

  18. #18
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    see attached sheet .... Sept. 15 Closing balance will be Ope Stock for Oct. 15
    Attached Files Attached Files

  19. #19
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    Every thing was working fine but than i am choose November month the monthly report sheet IN C5 Column show October month & I5 column show November month sir thanking you sir

  20. #20
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    not getting what are you saying??

  21. #21
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    than i am choose November month the monthly report sheet In C5 Column show October month & c7 to f26 Columns Show October month opening balance, purchase, sale & balance & I5 column show November month & H7 to K26 Columns Show november month total purchase stock, total sale stock & balance stock sir thanking you sir

  22. #22
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    please attach file in which you are working...

    If you are working in file attached in post #18 then you are on wrong track because in that file formulas will not give monthly results.
    It is just for your reference to show ope. closing balance....
    You are required to put formulas like I7 to I26 and J7 to J26..

    see attached file and update all..
    Attached Files Attached Files

  23. #23
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    i am insert these Monthly Report & Sale Summary sheets in my Final excel sheet all was working fine but Monthly Report Sheet Total Sale Stock & Balance Stock Columns Formula Was not Working & Sale Summary Sheets B4 to AF23 Formula Was not Working Please Resolve this sir i am send the my original Excel Sheet please see the attachments sir & Resolve this issue sir this is a final request sir thanking you sir
    Attached Files Attached Files

  24. #24
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Hii see attached sheet All done

    Also note I have added ".Cells(LastMasterRow, 26).Value = txtTOTAL.Value" to CmdAdd button so no need to keep blank formula in Col. Z in "Purchase Sheet"
    Attached Files Attached Files

  25. #25
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    Every thing was working fine but than i am click on add purchase the Add purchase User form was display than i add quantity in text box this was display is very slow & fill the quantity in every Textbox & click on the Add button this Command is working very slow process please resolve the slow process issue of all excel sheets thanking you sir

  26. #26
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    There is huge formulas and macro coding so it will little bit slow...
    Try to remove formulas in col Y and AD and AA in purchase sheet add some coding so that it will fill automatically when you press "Add purchase" button.... now mark this thread as Solved.. and "Add Reputation" if done..

  27. #27
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    R/sir
    i am not understand & all other sheet data entry process is very slow for example in monthly report sheet the drop down menu was working slow process please sir resolve this sir & all sheets data entry process is fast sir thanking you sir

  28. #28
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    501

    Re: formula for show monthly purchase stock, sale stock & balance stock

    You please start new thread for this issue because I am not able to find why it is slow..

    Experts will tackle issue...

    now mark this as Solved..

  29. #29
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    please reply sir

  30. #30
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    Please sir now you can try to resolve this issue sir

  31. #31
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    respected LeoTaxi sir
    than i am click on the create report the total purchase stock was not display & than i am choose September the total Purchase stock was pickup from purchase sheet than i am choose October Month the total Purchase stock was pickup from purchase sheet All October months dates the total sale stock was display wrong than i am choose September month the total sale stock was pickup from sheet2(1-9-2015), than i am choose October month the total sale stock was pickup from sheet3(1-10-2015),sheet4(2-10-2015), sheet6(3-10-2015) than i add new sheet this new sheet Total sale stock was automatically plus in total sale stock thanking you sir

  32. #32
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: formula for show monthly purchase stock, sale stock & balance stock

    respected mangesh.mehendale
    sir i am found the fast data entry vba macro code please correct add purchase user form vba macro code than i am click on the add purchase button & fill the all text box & click on the add button the data was add on sale sheet please correct this code sir for add the data to purchase sheet sir i am send the attachments sir

+ 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. [SOLVED] Formula for Purchase and sale total in current stock
    By vivek_vx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2016, 07:13 PM
  2. Invoice sale, purchase and stock details problem
    By dj_sajju in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2015, 12:23 PM
  3. 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
  4. Low stock and/or High Stock Formula required
    By SaleenaKhan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2013, 01:51 PM
  5. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  6. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  7. Replies: 0
    Last Post: 09-25-2012, 09:39 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