Hi,

I have a number of worksheets with Pivot Tables on them. I also have a list
of Rowfields.

Lets say the worksheets are called Sheet1, Sheet2 etc and the RowFields are
called Field1, Field 2 etc.

I'm trying to create a list on a control sheet (CONTROL) with the following
layout:

Sheet Field Exists
Sheet1 Field1 Yes
Sheet1 Field 2 No
Sheet2 Field 1 Yes
Sheet2 Field 2 Yes
............................
.............................

And so on.....





--
Andrew