+ Reply to Thread
Results 1 to 1 of 1

inventory reconciliation and storage calculation

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    2013 professional

    inventory reconciliation and storage calculation

    Hello folks,

    I use multple vlookups and offsets formula to compare month beginning and month ending inventory to calculate activity for the month and then I have to calculate storage based on tiered pricing.
    while writing formulas and doing this manually has worked out great , I realize there are smarter ways to do this and Im hoping to get some help.

    I have 2 sheets uploaded ( beginning & ending)
    there are typically more SKU's at the ending of the month than beginning as new inventory is usually checked in.
    I have to find a way to merge both sheets by making sure no duplicates are creates and generating a beginning balance, ending balance and a column for activity.

    see attached example (activity template)
    anyway you can help me with a macro for this?

    My steps after I have the macro will be to do a vlookup by customer list to create pivot tables and then copy each of that into an individual invoice ( activity template) and then calculate storage ( which is tiered pricing) and charge them.

    with this macro you will be saving me about a days worth work.
    Attached Files Attached Files

+ 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. Aged Inventory Calculation
    By stephenwilliams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2014, 11:22 PM
  2. HELP - Inventory Calculation Formula
    By cbuxtonasks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2014, 05:08 PM
  3. Replies: 1
    Last Post: 10-09-2013, 11:44 AM
  4. Inventory Reconciliation
    By CKU in forum Excel General
    Replies: 10
    Last Post: 07-08-2013, 12:54 PM
  5. Excel 2007 : Inventory calculation
    By lifeisboost in forum Excel General
    Replies: 5
    Last Post: 09-06-2010, 02:58 AM

Tags for this Thread


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