+ Reply to Thread
Results 1 to 3 of 3

How to Reflect Calculation for worksheet to another worksheet

  1. #1
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    How to Reflect Calculation for worksheet to another worksheet

    Hi Gurus,

    can you please help me build a formula to my Warehouse Management Worksheet

    I Have the following

    Quantity Received
    Quantity Used
    Quantity on Hand

    Then on my Other worksheet which I used to track the Lot No. and which a certain Material was used in

    Quantity Dispensed; and
    Quantity Returned



    If I issue an Inventory Card to them they will fill out the Quantity Dispensed and The Quantity of the Material Returned

    After they returned the Card I will also record it to my Lot Track Worksheet ( Quantity Dispensed; and
    Quantity Returned)

    I Like that as I record the Quantity Returned and Quantity Dispensed It will also reflect to my Quantity Used and Quantity on Hand of my other worksheet.

    I would appreciate if you can help me figure out the right calculation combination of my problem.

    Thank you so much.
    Last edited by thong127; 10-13-2015 at 02:35 PM. Reason: Change Title

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,596

    Re: Help for calculation formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Help for calculation formula

    Hello All,

    Just following up regarding my question. any help is highly appreciated.

    Thank you so much.

+ 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. How to read formula result for calculation of another formula?
    By Shad0wguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2013, 02:15 PM
  2. excel formula calculation - how to insert the right formula
    By Manila.Boracay in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2011, 04:21 AM
  3. Calculation Formula
    By m_789 in forum Excel General
    Replies: 2
    Last Post: 11-10-2011, 10:04 AM
  4. help with calculation formula ....
    By ujjawal in forum Excel General
    Replies: 4
    Last Post: 07-27-2009, 11:47 AM
  5. calculation in an if formula
    By Sharon L. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2006, 02:17 PM
  6. [SOLVED] i need help with a calculation formula...
    By David Billigmeier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 10:05 PM
  7. Re: base formula calculation on whether different cell has formula
    By Bill Kuunders in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2005, 05:05 PM
  8. base formula calculation on whether different cell has formula
    By rcmodelr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2005, 08:05 PM

Tags for this Thread

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