Results 1 to 5 of 5

Inventory Stock Formula

Threaded View

  1. 03-10-2021, 03:35 AM #1
    samwignall
    samwignall is offline
    Registered User
    Join Date
    06-16-2020
    Location
    Australia`
    MS-Off Ver
    365
    Posts
    8

    Inventory Stock Formula

    Tab 1 = Stock Received Into Business
    Tab 2 = Stock distributed to Employees in the business
    Tab 3 = Inventory Stock

    In Tab 3 I have a table, and want to be able to pull in C4 Qty of 'Womens T Shirt' IN 'Karratha Branch'.
    This needs to add all the stock registered into Karratha in Tab 1, and deduct all the Stock distributed in Tab 2

    Please help
    Attached Files Attached Files
    Last edited by samwignall; 03-10-2021 at 04:03 AM.
    Reply With QuoteRegister To Reply
« 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] Automate barcode scanning into an inventory sheet to add to actual inventory and subtract
    By Robert7474 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-28-2020, 12:06 PM
  2. Excel Inventory - create shopping list based on inventory taken
    By shahzzy in forum Excel General
    Replies: 3
    Last Post: 11-05-2020, 12:08 PM
  3. I need a formula for an inventory workbook for to calculate sales and add inventory
    By kareylee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-18-2020, 03:56 AM
  4. [SOLVED] Formula for Inventory Summary based on Inventory List
    By EWolfe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2018, 10:35 AM
  5. To create Waterfall Chart for Production,Opening Inventory Sales and Closing Inventory
    By BENGALAYJR86 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-04-2018, 02:52 AM
  6. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 08:58 PM
  7. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 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