"Frits algie" wrote in message
...
Make one Pivot table, in which you define the range as the columns fi A:D.
This will tackle new entry's. It will also show one blanc, which you can
shut
off.

After you have made the first pivot table, copy the pivottable to a new
sheet and then set it as you wish.
as long as you keep alle pivittables in the same workbook, refreshing one
table will automaticly refresh the other tables.

Hope trhis helps

Jim & Frits

Many thanks for the helpful suggestions. I'll try them out tomorrow!

Regards,

V