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

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

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" wrote:

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

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




"Albert" wrote in message
...
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" wrote:

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

By all three.


"Nigel" wrote:

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




"Albert" wrote in message
...
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" wrote:

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