About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tracking values from different sheets	Rao Ratan Singh	Excel Discussion (Misc queries)	2	December 11th 06 11:00 AM
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?	Corey	Excel Programming	2	December 11th 06 01:35 AM
Tracking values from different sheets.	Rao Ratan Singh	Excel Discussion (Misc queries)	0	December 2nd 06 11:16 AM
Tracking Cost Price from Different Sheets	Rao Ratan Singh	Excel Discussion (Misc queries)	0	November 30th 06 10:05 AM
How to insert tracking numbers into my webpage for RMA tracking	wiglady	Excel Discussion (Misc queries)	0	April 4th 06 12:44 PM

Menu

About Us