I have an excel worksheet that has sales data in it. Each tab in it
represents a different years worth of sales info.

Each tab has got a number of rows in it, that vary from 21-26 different
rows. The names are all the same, it's just that in some years, the
customer bought product X, and in some other years, they did not buy product
X, so there's no entry for it.

What my first tab needs to have in it is a row that has product X, product Y
and product Z and then a column for each year, as in 1994, 1995, etc. So if
they bought product X in 94, 95 and 96, there'd be columns with the numbers
in them. If they bought Product Y in 94 & 96 but not in 95, it'd be a zero
in the 1995 column where there was no corresponding row from that tab.

Is there a way to do this without endless cutting & pasting?

Thanks,

S

The best way to do this is probably to use pivot table based on multiple
consolidation ranges. Just click pivot table wizard and follow instructions.

RADO


"Steve Chatham" wrote in message
...
I have an excel worksheet that has sales data in it. Each tab in it
represents a different years worth of sales info.

Each tab has got a number of rows in it, that vary from 21-26 different
rows. The names are all the same, it's just that in some years, the
customer bought product X, and in some other years, they did not buy
product
X, so there's no entry for it.

What my first tab needs to have in it is a row that has product X, product
Y
and product Z and then a column for each year, as in 1994, 1995, etc. So
if
they bought product X in 94, 95 and 96, there'd be columns with the
numbers
in them. If they bought Product Y in 94 & 96 but not in 95, it'd be a
zero
in the 1995 column where there was no corresponding row from that tab.

Is there a way to do this without endless cutting & pasting?

Thanks,

S