Newtonboy,

You could approach this with vlookup or index & match to retrieve the values
based on your unique identifier.

For vlookup --> http://www.contextures.com/xlFunctions02.html
For index & match --> http://www.contextures.com/xlFunctions03.html

If you need help figuring in this stuff out don't hesitate to ask.

ROCK ON!

Scott



"Newtonboy" wrote:

>
> 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
>
>