software

Windows XP Professional
Office 2000

I have a spreadsheet where daily data is entered. It is set up similar
to following example:DatePortShpts Pcs

4-NovEWR25,69330,615
4-NovIND40,593143,778
4-NovOAK25,04743,928
4-NovMEM209,126290,865
4-NovANC93,392193,251
4-NovMIA10,15311,621
11-NovEWR31,72937,687
11-NovIND37,413135,287
11-NovOAK27,14845,139
11-NovMEM215,890290,591
11-NovANC92,635178,298
11-NovMIA11,23313,744
18-NovEWR31,97937,329
18-NovIND41,807153,256
18-NovOAK29,08150,603
18-NovMEM217,948300,548
18-NovANC95,017190,090
18-NovMIA10,58312,428

On a difference worksheet, I want to compile trend information for each
port so that a table is set up as below:DatePortShpts Pcs
4-NovANC93,392193,251
11-NovANC92,635178,298
18-NovANC95,017190,090

DatePortShpts Pcs
4-NovEWR25,69330,615
11-NovEWR31,72937,687
18-NovEWR31,97937,329

Any ideas on how to best achieve the needed output? I familiar with
VLOOKUP, but unsure how to use it to look for Date AND Port...Thanks in advance for any help you can give...

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express
Can't you just sort by colB and then col A

--
Don Guillett
SalesAid Software

quot;Rita Palazziquot; gt; wrote in message
...
gt; Windows XP Professional
gt; Office 2000
gt;
gt; I have a spreadsheet where daily data is entered. It is set up similar to
gt; following example:
gt;
gt;
gt; Date Port Shpts Pcs
gt;
gt; 4-Nov EWR 25,693 30,615 4-Nov IND 40,593 143,778 4-Nov OAK 25,047 43,928
gt; 4-Nov MEM 209,126 290,865 4-Nov ANC 93,392 193,251 4-Nov MIA 10,153 11,621
gt; 11-Nov EWR 31,729 37,687 11-Nov IND 37,413 135,287 11-Nov OAK 27,148
gt; 45,139 11-Nov MEM 215,890 290,591 11-Nov ANC 92,635 178,298 11-Nov MIA
gt; 11,233 13,744 18-Nov EWR 31,979 37,329 18-Nov IND 41,807 153,256 18-Nov
gt; OAK 29,081 50,603 18-Nov MEM 217,948 300,548 18-Nov ANC 95,017 190,090
gt; 18-Nov MIA 10,583 12,428
gt;
gt;
gt;
gt; On a difference worksheet, I want to compile trend information for each
gt; port so that a table is set up as below:
gt;
gt;
gt; Date Port Shpts Pcs
gt; 4-Nov ANC 93,392 193,251 11-Nov ANC 92,635 178,298 18-Nov ANC 95,017
gt; 190,090
gt;
gt; Date Port Shpts Pcs
gt; 4-Nov EWR 25,693 30,615 11-Nov EWR 31,729 37,687 18-Nov EWR 31,979 37,329
gt;
gt;
gt;
gt; Any ideas on how to best achieve the needed output? I familiar with
gt; VLOOKUP, but unsure how to use it to look for Date AND Port...
gt;
gt;
gt; Thanks in advance for any help you can give...
gt;
gt; Rita Palazzi
gt; Senior Engineer / Global Trade Services
gt; FedEx Express
gt;
gt;
I only showed a small portion of what the input sheet looks like.
I'm trying to get this worksheet (to be used as only chart data sheet)
set up to automatically populate as, on a weekly basis, we chart 13
weeks of information and anywhere from 25 - 50 charts will be created.

We regularly set up a quot;chart data sheetquot; so that when updating the
charts, only ONE week-ending date is input and then all other cells
update using the input sheet as the source. This stops us from having
to constantly change cell references on every chart we produce. The
quot;chart data sheetquot; changes by week, hence the charts change automatically.

It isn't feasible to Copy, Paste, Sort, every week when there is bound
to be a way to do it programatically.Don Guillett wrote:

gt; Can't you just sort by colB and then col A
gt;It sounds to me like the AutoFilter ( Data gt; Filter gt; AutoFilter ) would help
a lot. It can also be automated with macros.........

Vaya con Dios,
Chuck, CABGx3

quot;Rita Palazziquot; wrote:

gt; Windows XP Professional
gt; Office 2000
gt;
gt; I have a spreadsheet where daily data is entered. It is set up similar
gt; to following example:
gt;
gt;
gt; DatePortShpts Pcs
gt;
gt; 4-NovEWR25,69330,615
gt; 4-NovIND40,593143,778
gt; 4-NovOAK25,04743,928
gt; 4-NovMEM209,126290,865
gt; 4-NovANC93,392193,251
gt; 4-NovMIA10,15311,621
gt; 11-NovEWR31,72937,687
gt; 11-NovIND37,413135,287
gt; 11-NovOAK27,14845,139
gt; 11-NovMEM215,890290,591
gt; 11-NovANC92,635178,298
gt; 11-NovMIA11,23313,744
gt; 18-NovEWR31,97937,329
gt; 18-NovIND41,807153,256
gt; 18-NovOAK29,08150,603
gt; 18-NovMEM217,948300,548
gt; 18-NovANC95,017190,090
gt; 18-NovMIA10,58312,428
gt;
gt;
gt;
gt;
gt; On a difference worksheet, I want to compile trend information for each
gt; port so that a table is set up as below:
gt;
gt;
gt; DatePortShpts Pcs
gt; 4-NovANC93,392193,251
gt; 11-NovANC92,635178,298
gt; 18-NovANC95,017190,090
gt;
gt; DatePortShpts Pcs
gt; 4-NovEWR25,69330,615
gt; 11-NovEWR31,72937,687
gt; 18-NovEWR31,97937,329
gt;
gt;
gt;
gt;
gt; Any ideas on how to best achieve the needed output? I familiar with
gt; VLOOKUP, but unsure how to use it to look for Date AND Port...
gt;
gt;
gt; Thanks in advance for any help you can give...
gt;
gt; Rita Palazzi
gt; Senior Engineer / Global Trade Services
gt; FedEx Express
gt;
gt;
gt;