I’m trying to keep up with the amount of days my warehousestores tires. I already fill out a un-load and store form with a date for theinbound tires. I copy that date to my warehouse sheet as follows: = 'Inbound TU '!$H$1 This puts date in a blank cell on my warehouse sheet.
This checks to see if anything is already in the row and ifso the earliest date will reflect in the box below the count of tires.=IF (D1>=1,$A$34,"")<o
></o> Myproblem is the date is live, meaning it updates every day. I need it to stay onthe day I copied from the inbound put away sheet.<o></o>If I can do this I can do condition codes to show when mytires get old and highlight that block. I am not educated enough to understandthe VBA lingo yet. Just want to date the tires without having to enter everyrow. Can it be done?<o
></o><o
> </o>[TABLE="class: MsoNormalTable, width: 348"]
<tbody>[TR]
[TD="width: 57, bgcolor: transparent"] <o
></o>[/TD]
[TD="width: 45, bgcolor: transparent"] <o
></o>[/TD]
[TD="width: 43, bgcolor: transparent"] <o
></o>[/TD]
[TD="width: 43, bgcolor: transparent"]
1<o></o>
></o>[TD="width: 45, bgcolor: transparent"]
2<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
3<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
4<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
5<o></o>
></o>[TD="width: 41, bgcolor: transparent"]
6<o></o>
></o>[TD="width: 63, bgcolor: transparent"]
7<o></o>
></o>[/TR]
[TR]
[TD="width: 57"]
Bay - 1<o></o>
></o>[TD="width: 45"]
Tire Code<o></o>
></o>[TD="width: 43"]
<o></o>
></o>[TD="width: 43"]
5602<o></o>
></o>[TD="width: 45"]
22174<o></o>
></o>[TD="width: 43"]
5602<o></o>
></o>[TD="width: 43"]
5602<o></o>
></o>[TD="width: 43"]
5602<o></o>
></o>[TD="width: 41"]
<o></o>
></o>[TD="width: 63"]
5602<o></o>
></o>[/TR]
[TR]
[TD="width: 45"]
Qty<o></o>
></o>[TD="width: 43"]
<o></o>
></o>[TD="width: 43"]
102<o></o>
></o>[TD="width: 45"]
114<o></o>
></o>[TD="width: 43"]
102<o></o>
></o>[TD="width: 43"]
102<o></o>
></o>[TD="width: 43"]
100<o></o>
></o>[TD="width: 41"]
365 <o></o>
></o>[TD="width: 63"]
102<o></o>
></o>[/TR]
[TR]
[TD="width: 57, bgcolor: transparent"] <o
></o>[/TD]
[TD="width: 45, bgcolor: transparent"]
days <o></o>
></o>[TD="width: 43"]
<o></o>
></o>[TD="width: 43"]
31<o></o>
></o>[TD="width: 45"]
4<o></o>
></o>[TD="width: 43"]
31<o></o>
></o>[TD="width: 43"]
31<o></o>
></o>[TD="width: 43"]
31<o></o>
></o>[TD="width: 41, bgcolor: transparent"]
red <o></o>
></o>[TD="width: 63"]
25<o></o>
></o>[/TR]
[TR]
[TD="width: 57, bgcolor: transparent"] <o
></o>[/TD]
[TD="width: 45, bgcolor: transparent"]
<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
<o></o>
></o>[TD="width: 45, bgcolor: transparent"]
<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
<o></o>
></o>[TD="width: 43, bgcolor: transparent"]
<o></o>
></o>[TD="width: 41, bgcolor: transparent"]
<o></o>
></o>[TD="width: 63, bgcolor: transparent"]
<o></o>
></o>[/TR]
</tbody>[/TABLE]
<o
> </o>
