L
Lorraine
Hi
I am trying to create a macro for a report that gets
generated from an asset tracking program. It returns a
list with a column for UIC code, a column for location
issued from and one for location issued to plus a date
issued column. So you might have one item issued out from
A to B, then the same item returned from B to A on a
different line. Here's the dilemma, I need to track how
many days the item was out; not sure how to do this when
it would have to refer to 2 different lines and the
second problem is that it also has to track those items
that only went out and didn't come back. Not sure if
this is possible but would sure appreciate any assistance.
I am trying to create a macro for a report that gets
generated from an asset tracking program. It returns a
list with a column for UIC code, a column for location
issued from and one for location issued to plus a date
issued column. So you might have one item issued out from
A to B, then the same item returned from B to A on a
different line. Here's the dilemma, I need to track how
many days the item was out; not sure how to do this when
it would have to refer to 2 different lines and the
second problem is that it also has to track those items
that only went out and didn't come back. Not sure if
this is possible but would sure appreciate any assistance.