IgnBan
01-29-2008, 06:29 PM
Is it possible to use a formula to keep track of cell value in a sheet from another sheet base on the date and time input it?
This is what I?m trying to accomplish; I got a workbook where we keep track of inventory of items on several warehouses locations ?A?, ?B???Y? and ?Z?, these items are move constantly from warehouse location during the day. People moving these items not always input the movement right away, Ex. person 1 can move item 12 to warehouse location ?H? at 6:00 AM and not record the movement, then person2 can move the same item (12) to location ?S? at 9:00 AM and recorded it, then at 10:30 AM person1 come to the log book and record movement he made inputting below the 9:00 AM time with his 6:00 AM movement. As you can see the time and some time date of movement doesn?t follow a descending patter. My question is; How can I keep track in a workbook of the movement of items base on the most resent time input it?.
I made a sample workbook of what ours looks like. What I want is to keep in Sheet 1 ; Item Number and Item Location , on Sheet2 (this is the input log) ; Item Number, Time, Date, Item Location. Is it possible with a formula (or code) to when an item is enter in Sheet1 with an expression go to Sheet2 and scan the same Item Number and look for the most recent (date-Time) location?. And copy that location in Sheet1?..and if someone else come and inputs another time and location of more earlier time, update it?...and also can it be conditionally formatted in Sheet 2 so the most recent date-time input for Items be bolt ?
This is what I?m trying to accomplish; I got a workbook where we keep track of inventory of items on several warehouses locations ?A?, ?B???Y? and ?Z?, these items are move constantly from warehouse location during the day. People moving these items not always input the movement right away, Ex. person 1 can move item 12 to warehouse location ?H? at 6:00 AM and not record the movement, then person2 can move the same item (12) to location ?S? at 9:00 AM and recorded it, then at 10:30 AM person1 come to the log book and record movement he made inputting below the 9:00 AM time with his 6:00 AM movement. As you can see the time and some time date of movement doesn?t follow a descending patter. My question is; How can I keep track in a workbook of the movement of items base on the most resent time input it?.
I made a sample workbook of what ours looks like. What I want is to keep in Sheet 1 ; Item Number and Item Location , on Sheet2 (this is the input log) ; Item Number, Time, Date, Item Location. Is it possible with a formula (or code) to when an item is enter in Sheet1 with an expression go to Sheet2 and scan the same Item Number and look for the most recent (date-Time) location?. And copy that location in Sheet1?..and if someone else come and inputs another time and location of more earlier time, update it?...and also can it be conditionally formatted in Sheet 2 so the most recent date-time input for Items be bolt ?