Some thoughts, if you are using columns to record each days status report,
and I assume you want a new column for each load, then unless you are using
xl2007 you are limited to around 250 days which may be limiting.
Alternatively if the actual load date is not by column but only for each
change in customer you will still be limited to around 250 customer status
updates, which maybe enough, but now these are going to be difficult to
review by load date collectively as they will no longer be in the same
column!

I guess the bottom line is what and how do you want to use this data? If
your reviewing any one customer then store them as a database and have a
search form to bring all the customer events together or is it something
else?


--

Regards,
Nigel




"Albert" wrote in message
...
Hi Guys,

We get a spreadsheet everyday from our supplier with the status of our
production. These spreadsheets are snapshots of our production (that is
the
status change of an order is only shown as the date of the spreadsheet and
not showing the dates the statuses changed for each order)

I would like to Merge all the sheets (This obviously gives me duplicate
entries for the same customer number) so that I have a single customer
number
along the rows. While the columns(status) will show the date the status
was
date_in_status.
This will be updated on a daily basis with new sheets.

Any Ideas?

Cheers
Albert