A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Links and Linking in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Cycle counts from linked sheets: everchanging quantities



 
 
Thread Tools Display Modes
  #1  
Old September 13th 12, 09:14 PM
tubbycricket tubbycricket is offline
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 1
Default Cycle counts from linked sheets: everchanging quantities

Hey everyone, this is my first time here, I just had a question in my mind and wanted to know if such a thing was possible or nonsensical:

The industry I work in, we use Excel to keep track of cycle counts we do on our inventory on hand from time to time. When one of our guys gives us a quantity, we enter that quantity into one cell while an adjacent cell holds the original quantity on hand to compare it to.

For the time being, almost all the data is static and manually entered from various sources, but mainly from our company ERP software.

What I want to do is this: I want to pull the quantity on hand for a specific item from another Excel file that dynamically updates itself on that parameter.

So, in essence, each time the sheet opens up, the quantity on hand would change: one day the item can have 100 pieces, the next day it can drop to 90 pieces if 10 pieces were picked. But in the interim, I had cycle counted 95 pieces.

Now since there was a drop of 10 pieces, I would have to drop the cycle count figure accordingly to 85 pieces from the original 95.

Question is: is there a way for Excel to recognize the drop in quantity on hand during each update, and then apply that difference to other cells as well?

Please let me know if you need more information, thanks.
Ads
  #2  
Old May 3rd 13, 12:10 PM
Aries86 Aries86 is offline
Junior Member
 
First recorded activity by ExcelBanter: May 2013
Posts: 1
Default

I really like the link... I have found here so many information, I'll share this to my friends...

Last edited by Aries86 : November 19th 14 at 09:06 AM.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Everchanging number of rows JohnUK Excel Programming 5 February 3rd 10 01:19 PM
how do i set up attendance sheets for 2 week repeting work cycle bill Excel Discussion (Misc queries) 0 January 5th 09 02:58 PM
crtl + page down or up does not cycle through sheets in excel 2007 John G.[_2_] Excel Discussion (Misc queries) 4 May 8th 08 05:21 PM
Update sheets & cycle Sinner Excel Programming 2 March 2nd 08 10:34 PM
Cycle through multiple sheets karimhemani Excel Programming 2 March 19th 07 06:18 AM


All times are GMT +1. The time now is 03:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.