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