+ Reply to Thread
Results 1 to 11 of 11

Automate my stock fabric

  1. 06-17-2022, 07:05 AM #1
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Thumbs up Automate my stock fabric

    Hi, friends,
    Please help me to automate the stock fabrics with excel or VBA code,
    I have a master requisition number, which aginst some requisition can be created, but
    I have only one master which will be referred to in reference no, if I transfer fabric with against a lot no then from my total fabrics it will be minus
    I have different requisition numbers which is no matter, but all the sub-requisitions are under the master requisition, from where all fabrics are delivered and stock can be measured.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-17-2022, 08:40 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,202

    Re: Automate my stock fabric

    Please try

    in F2

    =IF($C2="Master",SUMIFS($E$2:$E$13,$A$2:$A$13,$A2)-SUMIFS($E$2:$E$13,$B$2:$B$13,$A2),"")

    Copy down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 06-17-2022, 09:34 AM #3
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    Thanks!
    John,you are really awesome!
    Reply With QuoteRegister To Reply
  4. 06-19-2022, 06:01 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Automate my stock fabric

    Please continue here with your update request.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 06-19-2022, 06:11 AM #5
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    Thanks AliGW,
    Please help me to automate this file against LOT no,in order to the requisitions number and sub requisitions number it will keep the master requisitions number fixed,but it will minus against lot no with against order reference no
    Please help me to automate this!
    Thanks in advance!
    Reply With QuoteRegister To Reply
  6. 06-19-2022, 06:29 AM #6
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    This is a new sample file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 06-19-2022, 01:27 PM #7
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    Hey John,
    Can you give me a suggestions please?
    Reply With QuoteRegister To Reply
  8. 06-19-2022, 01:41 PM #8
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,202

    Re: Automate my stock fabric

    Please try

    =IF($C2="Master",SUMIFS($E$2:$E$20,$A$2:$A$20,$A2,$D$2:$D$20,$D2)-SUMIFS($E$2:$E$20,$B$2:$B$20,$A2,$D$2:$D$20,$D2),"")
    Reply With QuoteRegister To Reply
  9. 06-20-2022, 12:41 PM #9
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    Its working
    Thank you so much #JohnTopley
    Reply With QuoteRegister To Reply
  10. 06-27-2022, 11:31 AM #10
    Fahim Al Mamun
    Fahim Al Mamun is offline
    Registered User
    Join Date
    06-15-2022
    Location
    Bangladesh
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Automate my stock fabric

    John, please help me, if there have any Receive in fabric than it will be add to the stock fabric ,how can I calculate it?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 06-27-2022, 01:00 PM #11
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,202

    Re: Automate my stock fabric

    Try

    =IF($C2="Master",SUMIFS($E$2:$E$20,$A$2:$A$20,$A2,$D$2:$D$20,$D2)-SUMIFS($E$2:$E$20,$B$2:$B$20,$A2,$D$2:$D$20,$D2)+SUMIFS($E$2:$E$20,$D$2:$D$20,D2,$C$2:$C$20,"Receive"),"")
    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. Trying to build Function to calculate average of stock returns, with stock prices as input
    By jameslaughlin129 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2017, 05:18 PM
  2. [SOLVED] formula for show monthly purchase stock, sale stock & balance stock
    By rana19 in forum Excel General
    Replies: 31
    Last Post: 10-28-2015, 01:54 AM
  3. Need help with fabric roll - number of max turns calculation
    By dgiardina in forum Excel General
    Replies: 5
    Last Post: 04-06-2015, 02:36 PM
  4. Identify the earliest expiry date on stock based on current stock levels
    By julie86xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 01:08 AM
  5. Stock inventory, subtract purchased stock from current stock and continue with second row
    By MURUGANRAJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2013, 02:26 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. Stock Trading - How to calculate entry/exits when a stock crosses over a moving average?
    By asudchiman in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1