Does Rowfields exists?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

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.....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating pivot table dynamically 2
How to determine order of row fields in pivot table 1
Remove all column and row fields from a pivot table 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel Moving data to sheet2 from sheet1 0
modified pivot table using a macro 2
Merging 2 sheets. 1
loop to copy paste 5

Back
Top