Tracking changes in sheets

[Albert]

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

 

[Nigel]

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?

 

[Albert]

Hi Nigel,

Yes this would be ideal. Unfortunately the company does not want to invest
in Acces as they have plans to develop a proprietary system later this year.
So in the mean time how can I do this in excel? And in particular measure the
days in a particular status?

Albert

 

[Nigel]

I was not suggesting Access but a database in Excel. How do you want to
view the data results by customer or status or date?

--

Regards,
Nigel
(e-mail address removed)

 

[Albert]

By all three.

I was not suggesting Access but a database in Excel. How do you want to
view the data results by customer or status or date?

--

Regards,
Nigel
(e-mail address removed)