+ Reply to Thread
Results 1 to 2 of 2

Calculating pallet movement

  1. #1
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Calculating pallet movement

    Hi,

    Please can i get some help with the attached file.

    in column H this is the running balance on the amount of boxes we have. Each week i will be deducting from this. when i enter a number in column i, j & k the running balance in column H will deduct. when this gets to 0 i would like this to automatically hide (not delete).

    Looking forward to your help.

    Thanks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Calculating pallet movement

    Hi @Mitch.Birlea

    You can try with this code,
    It only considers changes in columns I, J, K. but I can see in your book columns L, and M used for the same purpose.
    If you need them, then you can change the code acordingly
    Please Login or Register  to view this content.
    Barriers are there for those who don't want to dream

+ 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. Calculation Pallet Movement
    By Mitch.Birlea in forum Excel General
    Replies: 5
    Last Post: 06-08-2017, 04:45 AM
  2. [SOLVED] Calculating pallet movement
    By Mitch.Birlea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2017, 11:48 AM
  3. Calculating pallet movement
    By Mitch.Birlea in forum Excel General
    Replies: 0
    Last Post: 06-02-2017, 07:00 AM
  4. Piece, Box and Pallet Qty. How to calculate each
    By unclejemima in forum Excel General
    Replies: 6
    Last Post: 05-05-2017, 06:33 PM
  5. [SOLVED] Calculating based on the better rate - per kg or pallet
    By someko in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-22-2015, 11:43 PM
  6. Replies: 0
    Last Post: 08-14-2012, 09:42 AM
  7. Pallet Calculation Problem
    By duvall73 in forum Excel General
    Replies: 1
    Last Post: 05-01-2010, 11:52 PM

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