Although, I think it's a good idea for each field to have a unique header, all
that's required is that each field have a header (non-empty cell).



Roger Govier wrote:

Hi

For a Pivot Table to work, each column has to have a unique heading in
the first row.
It does not matter if there is data in every column of each row.

From your posting, it is difficult to see your layout.

--
Regards

Roger Govier

"partsman_ba" wrote in message
...
What I would like on, say, Sheet2 would be:

1791XE 1
3231 or 3411 8
6500 1
6861 7
6862 1
7182 7

and if I add a new number to Sheet1, it shows up on my list

"partsman_ba" wrote:

Roger,

Here's a small piece of what the top looks like:

4J FILTERS

UNIT # YR/MAKE LUBE AIR FUEL
PRIMARY SECONDARY
INNER
10 07 BLUEBIRD 7182 6861 3231 or 3411
11 07 BLUEBIRD 7182 6861 3231 or 3411
12 07 BLUEBIRD 7182 6861 3231 or 3411
13 07 BLUEBIRD 7182 6861 3231 or 3411
14 08 BLUEBIRD 7182 6861 3231 or 3411
15 08 BLUEBIRD 7182 6861 3231 or 3411
20 03 BLUEBIRD 7182 6500 3231 or 3411
21 06 BLUEBIRD 1791XE 6861 6862 3231 or 3411

So, not all fields are full, and headings are split - can it still
work?



"Roger Govier" wrote:

Hi

Provided each of your columns has a header title in row 1, it
sounds an
ideal candidate for a Pivot Table report.
Take a look at Debra Dalgleish's site and scroll down to Pivot
Tables
for assistance on how to set one up.
http://www.contextures.com/tiptech.html

or Mike Alexander's site
http://www.datapigtechnologies.com/f...es/pivot1.html
--
Regards

Roger Govier


"partsman_ba" wrote in
message
...
Ideally, I would like it to automatically update - if I put in a
new
filter
number, it would be added to the sorted list with an occurence of
1,
or if I
add an already used filter to a new vehicle, it will add another
occurence to
the list. Am I asking too much?

"partsman_ba" wrote:

Here's what I have:

A spreadsheet sent to me with a list of filter part numbers,
with
each
vehicle having it's own row and each type of filter (air, oil,
etc)
having
it's own column. I would like to create from this data a sorted
list
of each
different filter part number, along with a count of how many
times
that part
number is on the sheet. Part numbers contain both numeric and
alpha
characters in some cases. It seems like something not so hard to
do,
but I've
been bashing my head for some time!








--

Dave Peterson