Dear All,

I am not the best hand @ Excel, so would like your help on this.

The situation is something like this....

I deal in timber. I receive logs in my log park. When ever I receive a
log in my log park, each log is given a unique number and its details
liek the diameter, length, speies, volume etc. are noted down. All
these dataare then entered into Excel and maintained there in simple
Excel sheet, columnwise.

Like this i accumulate thousands of logs. The problem ocurs when i ship
out these logs. The logs are not stacked in any order. They are just
stacked randomly. So, out of thousands of logs, as soon as I have a
shipment, I have to move hundreds of logs into the port.

Now, I have to prepare a packing list of all the logs that I have put
in the port. The problem is this paking list.

What I do now is to have two sheets, one is my master excel sheet whih
has details of all the logs and the other one is just the list of logs
that I have moved to the port.So i just copy and paste the list of logs
from the port list and paste in my master list, then sort and then
painstakingly, match each log to log.

What i wanted to know is, if theres a better way of organising the
data, so that I just enter the list of logs I have moved into the port
and i get all the details of the logs like the dia, length, volume
etc.

Or is Access a better way of managikng this data ? I use excel because
it is easier to manage with and my staff, who are not too familiar with
computers have grwon familiar with excel over time due to thsi data
entry trhat we do.

Pls suggest a better way of managing data. Looking forward to hearing
from you.

Regards,
Ajit


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=492821